SQL Examples

SELECT name, city

FROM customers

WHERE city =

(SELECT city

FROM customers

WHERE contact = "Gina Mullin");

SELECT [Part No], Sum(Quantity*[Unit Price]) AS Total

FROM orders

WHERE [Customer ID]=(SELECT id

FROM customers

WHERE contact = "Gina Mullin")

GROUP BY [Part No];