Answers | Skillshare Projects

107

5

Answers

1. What is wrong will the below SQL statement?

SELECT * FROM customers WHERE city = (‘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.

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

Answers:

1. Should be WHERE city IN (‘Brighton’,’Worthing’);

2. SELECT name, season, wholesale_price FROM products WHERE in_stock = 'True' AND wholesale_price > 25.00;

SELECT * FROM EMPLOYEES ORDER BY last_name;

Comments

Please sign in or sign up to comment.