Scribd
Upload
9 views1 page

Aa

Uploaded by

shwetasruthi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
9 views1 page

Aa

Uploaded by

shwetasruthi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Create a report in the below format to view the total value of orders processed for

each customer country by an employee. Use Order, Orderdetails & customer tables
from Northwind Database

EmployeeID | Customer_Country | Total_Value

SELECT shipcountry,employeeID,count((orderid)) FROM orders group by


shipcountry,EmployeeID ORDER BY ShipCountry

why not?? only order dets and orders table

Create a report to view first_dialed_no & last dialed_no of an employee, if both


are same then flag it as 'Y' else 'N'. use the attached sales dataset

EmployeeID | First_Dialed_No | Last_Dialed_No | Match

You might also like