Can I get help with this quiz ?

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

 

 

Relationships for Database14
Tuesday, November 04, 2014 Customers
CustomerId
CustomerName
ContactName
Address
City
PostalCode
Country Shippers
ShipperID
ShipperName
Phone OrderDetails
OrderDetailID
OrderID
ProductID
Quantity
Orders
OrderId
CustomerId
EmployeeId
OrderDate
ShipperID Products
ProductID
ProductName
SupplierID
CategoryId
Unit
Price Suppliers
SupplierID
SupplierName
ContactName
Address
City
PostalCode
Country
Phone

SQL – Quiz - 1
1) Show customer name and contact name for all the customers from Germany. Show me the
results in sort order of contact name.
2) Show me the Order ID and Order Date for the orders that were shipped by “Speedy Express”
(ShipperID = 1)
3) Show me the names of the products that are supplied either by “Exotic Liquid”
(SupplierID = 1) or “Grandma Kelly's Homestead” (SupplierID = 3)
4) Show me the name and city of customers with names starting with letter “B”
5) Between the countries Germany and Mexico, where do we have more number of customers?
6) Show me the names of the Products that are of category “Beverages”

Attachments:

• 1493442305-Relationship diagram for W3schools order3.pdf
• 1493442306-Sql quiz111.pdf