project questions | Skillshare Projects

13

--

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;

Comments

Please sign in or sign up to comment.