SQL Query Explanation Examples

SELECT * FROM dish WHERE NAME = 'Prawn Salad'

SELECT * FROM artist WHERE first_name = 'Vincent' AND ( last_name = 'Monet' OR last_name = 'Da Vinci' );

SELECT name FROM dish WHERE name = 'Prawn Salad' GROUP BY name HAVING count(*) = 1 ORDER BY name;

SELECT * FROM exhibit AS e1 JOIN exhibit AS e2 ON e1.id = e2.previous_id;

SELECT employee_id, last_name, first_name, salary, RANK() OVER (ORDER BY salary DESC) as ranking FRO...

WITH employee_ranking AS ( SELECT employee_id, last_name, first_name, salary, RANK() OVER (ORDER BY ...

WITH employee_ranking AS ( SELECT employee_id, last_name, first_name, salary, RANK() OVER (ORDER BY ...

SELECT employee_id, last_name, first_name, salary, ROW_NUMBER() OVER (ORDER BY employee_id) as ranki...

SELECT grain.product_name, box_size.description, grain.price_per_pound * box_size.box_weight FROM pr...

SELECT e1.first_name ||' '|| e1.last_name AS manager_name, e2.first_name ||' '|| e2.last_name AS emp...

SELECT first_name, last_name, salary FROM employee WHERE salary > ( SELECT AVG(salary) FROM employee )

SELECT first_name, last_name, salary FROM employee e1 WHERE salary > (SELECT AVG(salary) FROM employ...

SELECT last_name, first_name FROM employee INTERSECT SELECT last_name, first_name FROM employee_2020_jan