project questions


1. What is wrong will the below SQL statement?


SELECT * FROM customers WHERE city = (‘Brighton’,’Worthing’);


/* Question 1 */

SELECT * FROM address

WHERE city IN ('Brighton', 'Worthing');


2. Write an SQL query which will return the name, season and wholesale price of all products that are in stock where the wholesale price is greater than 25.00.


/* Question 2 */

SELECT name, season, wholesale_price FROM products

WHERE wholesale_price > 25;



3. Write an SQL which will order the employees table by last name alphabetically.


/* Question 3 */

SELECT * FROM employees

ORDER BY last_name;