Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1- Write an SQL query to show the CustomerName and Country of Customers. 2- Write an SQL query to show all Countries (no duplicates), order

1- Write an SQL query to show the CustomerName and Country of Customers.

2- Write an SQL query to show all Countries (no duplicates), order them alphabetically.

3- Write an SQL query to show the first name of all employees ordered by their last name in alphabetic order.

4- Write an SQL query to show the detail of all shippers.

5- Write an SQL query to show the top five expensive products.

6 - Write an SQL query to show all details of suppliers, only show five of them.

7- Write an SQL query to show all details of Categories.

8- Write an SQL query to show all details of Orders, show the recent ones on the top.

9- Write an SQL query to show product names, their units, and their prices.

10 - Write an SQL query to show all details of orders (from OrderDetails table).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Query Formulation And Administration Using Oracle And PostgreSQL

Authors: Michael Mannino

8th Edition

1948426951, 978-1948426954

More Books

Students also viewed these Databases questions

Question

CL I P COL Astro- L(1-cas0) Lsing *A=2 L sin(0/2)

Answered: 1 week ago