Resolved SQL Help using specific statements listed in forum

jag250

Active member
Joined
Sep 16, 2020
Messages
28
Programming Experience
1-3
USing theses Statements
    • no Table SELECT
    • SELECT FROM
    • WHERE
    • AND, OR, NOT, IN, LIKE
    • GROUP BY
    • HAVING (which also implies a join and a group by)
  • MC/TF portion
    • all multiple choice and True False


1. Show ship countries and a count of orders by Ship Country. Include orders placed in 1997 and shipped to Belgium, Mexico, and Poland.

2. Show year of order (YEAR(OrderDate)) and a count of orders by year of order. Only include orders after 1997. Include years with more than 40 counts of order.

3. Show ShipCountry, ShipCity, and the average Freight by by ShipCountry and then ShipCity.

4. Show a list of CustomerIDs, OrderID, ShipCountry and year of shipping (YEAR(ShippedDate)). Only include orders in 1996 and CustomerID begins with the letter E.

5. Show a list of CustomerIDs, OrderID, and Freight charges. Only include customers where their freight charges were over $30. Order by CustomerID and then OrderID. The freight charges shown in the table is in dollar. Create an additional column and show the freight charges in euros (1 Dollar = 0.86Euro).
 

Sheepings

Senior Programmer
Staff member
Joined
Sep 5, 2018
Messages
1,679
Location
UK
Programming Experience
10+
What exactly did you figure out? Maybe you'd like to share your conclusions?
 

Sheepings

Senior Programmer
Staff member
Joined
Sep 5, 2018
Messages
1,679
Location
UK
Programming Experience
10+
Good on you. Fair play :cool:
 
Top Bottom