Question
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
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
Customers CustomerId CustomerName ContactName Address PostalCode Country Shippers ShipperID ShipperName Phone Orders Order Id Customer Employeeld OrderDate ShipperID OrderDetails OrderDetailID Order ID ProductID Quantity Suppliers Supplier ID SupplierName Contact Name Address City PostalCode Country Phone Products ProductID ProductName upplierID Category Unit PriceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started