Write queries based on the Northwind Database Schema 1Select

Write queries based on the Northwind Database Schema

1.Select ContactName, CompanyName, ContactTitle, and Phone from the Customers table sorted byPhone.

2. Create a report showing Northwind\'s orders sorted by Freight from most expensive to cheapest.Show OrderID, OrderDate, ShippedDate, CustomerID, and Freight.

3. Create a report showing all the company names and contact names of Northwind\'s customers in Buenos Aires.

4. Create a report showing the order date, shipped date, customer id, and freight of all orders placed on May 19, 1997.

5. Create a report that shows the employee id, order id, customer id, required date, and shipped date of all orders that were shipped later than they were required.

6. Create a report that shows all orders that have a freight cost of more than $500.00.

7. Create a report that shows the company name, contact name and fax number of all customers that have a fax number.

8. Create a report that shows the company name, contact name and fax number of all customers that have a fax number. Sort by company name.

9. Create a report that shows the first and last names and birth date of all employees born in the 1950s.

10. Create a report that shows the shipping postal code, order id, and order date for all orders with a ship postal code beginning with \"02389\".

11. Create a report that shows the first and last names and cities of employees from cities other than Seattle in the state of Washington.

Products Column Name Condensed Typ Nula... ProductiD Column Name Condensed Type Nulable OrdertD Employees Column Nme Condensed .. Nul... Column Name Condensed Type EmployD int Nulable OustomerID nvarchan4) Column Nae Condensed Typ Nulable SupplertD ReportsTo Column Name Condens.. Nulable CustomerType nchar(10) No Column Name Condenced Typ Nulable nvarchar(15) EmployeeTerritories Column Name Condensed... N... Column Name Condens... Nul.. TerritoryD nvanchar20) No CustomerTypeID nchari No Yes Column Name Condensed Type Nullable Column Nme Condensed.. N... nvarcha(20) No TerritoryDecript... nchar No TeritoryID Column Name Condensed... Nul... ShipperID Column Ne Condens... Null... RegionID RegionDesoiption nchar0) No

Solution

1.Select Contactname,CompanyName,ContactTitle,Phone

from Customers

order by Phone;

2. Select OrderId,OrderDate,ShippedDate,CustomerID,Freight

from Orders

order by Freight Desc;

3. Select Companyname,ContactName

from Customers

where City = \'Buenos Aires\';

4. Select OrderDate,ShippedDate,CustomerID,Freight

from Orders

where OrderDate = \'May 19,1997\';

5. Select Employees.EmployeeID,Orders.OrderID,Customers.CustomerID,Orders.RequiredDate,Orders.ShippedDate

from Orders,Employees,Customers

where Orders.Shippeddate > Orders.RequiredDate;

6. Select * from Orders

where Freight >\'500\';

7. Select CompanyName,ContactName,Fax

from Customers

where Fax IS NOT NULL;

8.

Select CompanyName,ContactName,Fax

from Customers

where Fax IS NOT NULL

order by CompanyName;

9. Select FirstName,LastName,BirthDate

from Employees

where Year(BirthDate) = \'1950\';

10. Select ShipPostalCode OrderID,OrderDate

from Orders

where ShipPostalCode Like \'02389%\';

11. Select FirstName,LastName,City

from Employees

where NOT city =\'Seattle\';

12. Select * from Products

where(UnitPrice * Quantity/PerUnit) > AVG(UnitPrice * Quantity/PerUnit);