Question

Write a query that lists the top 3 suppliers ordered by their contact name in descending...

Customer > Customer int <p FirstName nvarchar(40) LastName nvarchar(40) City nvarchar(40) Country nvarchar(40) Phone nvarchar

  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
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
0 0
Add a comment Improve this question
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;

Add a comment
Know the answer?
Add Answer to:
Write a query that lists the top 3 suppliers ordered by their contact name in descending...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Create the following SQL Server queries that access the Northwind database Same as problem 3 but,...

    Create the following SQL Server queries that access the Northwind database Same as problem 3 but, limit the list to all customers who placed 3 or more orders. The product id, product name, last date that the product was ordered for all items in the Grains/Cereals category. (Hint: Use MAX) The product ID, product name, and number of distinct customers who ordered that product in 1996 Thank you. Categories Customers Employees Order Details Orders Products Shippers 9 CategoryID CategoryName Description...

  • Questions are based on the Northwind database. a. A data dictionary (Excel file) that describes each...

    Questions are based on the Northwind database. a. A data dictionary (Excel file) that describes each of the tables. (Attached in question) b.    Write good, clean SQL that answers the following questions. c.     Separate your queries as I have done in the following example. End each query with a semicolon (;) and insert the word "go" between each query. Queries can span multiple lines if required. Select CustomerID from Customers; go Select Count(*) from Employees; go Select max(productID) from Products; 18. Produce...

  • can someone solve these quick please and thank you! sql chapter 4 Query #1: List the...

    can someone solve these quick please and thank you! sql chapter 4 Query #1: List the company name, contact name, contact title and the phone number for customers who HAVE NOT put in an order. Use an outer join. Query #2: Create a listing displaying the employee first name, last name and the full name (First name space Last Name) of the person they report to (Supervisor). This is a self-join. If an employee does not report to anyone then...

  • Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins...

    Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins use from clause) Need to Create a Query to display products purchased by customers in Germany that were not purchased by customers in the US. Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode Country Phone char(5) varchar(40) varchar(30) varchar(30) varchar(60) varchar(15) varchar(15) varchar(10) varchar(15) varchar(24) varchar(24) Order Details Orders PK OrderID int FK CustomerlD char(5) FK Employeeld int...

  • Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins...

    Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins use from clause) Need to Create a Query because Northwind Traders has decided to increase their retail prices. Write a query that shows the product name, the current price, and the new price. Make sure the new price is listed to 2 decimal points. Follow below guidelines on new retail price: a.         If the category is beverages or dairy products, increase the price by...

  • Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins...

    Question for SQL in MS SQL Server Management Studio (Please don't use where clause for Joins use from clause) Need to Create a Query because Northwind Traders wants to make sure that all orders are shipped within 10 days. Display any orders that were not shipped within 10 days. Include the OrderID, the OrderDate, and the number of days it took before the order was shipped. Customers PK Customer D CompanyName Contact Name Contact Title Address City State OrRegion PostalCode...

  • If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top o...

    If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT