This project demonstrates how to extract and analyze data from an E-Commerce Dataset using MySQL Workbench. It showcases SQL skills such as data filtering, aggregation, joining tables, subqueries, ...
SQL is the de facto query language used to interact with databases. Since SQL is declarative, users express the intended result of their query rather than the concrete procedural steps to produce the ...
1️) Scalar Subquery in SELECT: SELECT e.emp_id, e.emp_name, e.salary, (SELECT ROUND(AVG(salary), 2) FROM employees WHERE dept_id = e.dept_id) AS dept_avg_salary FROM employees e; 2️) Correlated ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results