mysql workbench Database: murach Table : customers Example query Select from cus

Question

mysql workbench

Database: murach Table : customers Example query Select from customers where customer_id-3 1. Write a Select query to display details of Customers who are living in ohio state 2. Write a Select query to get Customers who don't have Fax number. 3. Write a Select query to display Customer address in One column (instead of 4 different colurmns Address, City, State, Zip) 4. Write a Select Query to sort zip code in Descending order. 5. Write a Select Query to display only 15 rows from customer table

Explanation / Answer

1. SELECT * FROM Customers WHERE State = 'ohio'

2. SELECT * FROM Customers WHERE Fax IS NULL;

3. SELECT CONCAT(Address,' ', City, ' ', State, ' ', Zip) FROM Customers.

4. SELECT Zip FROM Customers ORDER BY Zip DESC;

5. SELECT Top 15 FROM Customers.

Please check the code. If you have any doubts comment below and i am happy to help :)

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.