Question

Customer > Customer int <p FirstName nvarchar(40) LastName nvarchar(40) City nvarchar(40) Country nvarchar(40) Phone nvarchar(20) 8 IndexCustomerName Supplier Supplier int spk Order Order int <pk> CompanyName nvarchar(40) ContactName nvarchar(50) ContactTitle nvarchar(40) City nvarchar(40) Country nvarchar(40) Phone nvarchar(30) Fax nvarchar(30) 8 IndexSupplierName IndexSupplierCountry Id OrderDate datetime OrderNumber nvarchar(10) Customerld int TotalAmount decimal(122) 6 IndexOrderCustomerld IndexOrderOrderDate Product Orderltem SD (50) int Tk1 Product int ProductName nvarchar(50) Supplierld int UnitPrice decimal(12,2) Package nvarchar(30) Is Discontinued bit 8 IndexProductSupplierld 8 IndexProductName Orderltem spk Orderld int Productld int <fk2> UnitPrice decimal(12,2) Quantity int 8 IndexOrderltemOrderld 6 IndexOrderltemProductld

1. Write a query that lists the top 3 suppliers ordered by their contact name in descending order
2. Write a query that list all the countries that start with the litter M. Make sure you don’t have any duplicates.
3. List all product Name and unit price. Order the result by the unit price un descending order

Answer 1

Query for list top 3 supplier order by their contact name in descending order:-

SELECT TOP 3 * FROM SUPPLIER ORDER BY CONTACTNAME DESC; (not work in all system)

for oracle:

SELECT * FROM SUPPLIER WHERE ROWNUM <=3 ORDER BY CONTACTNAME DESC;

Query for all coutries start with letter M(for supplier):-

SELECT DISTINCT COUNTRY FROM SUPPLIER WHERE COUNTRY LIKE 'M%';

Query for all coutries start with letter M(for customer):-

SELECT DISTINCT COUNTRY FROM CUSTOMER WHERE COUNTRY LIKE 'M%';

List all product name and unit price(descending order):

SELECT PRODUCTNAME,UNITPRICE FROM PRODUCT ORDER BY UNITPRICE DESC;