Reference no: EM132326181
QUESTION 2
Remember --- need both the SQL and the output to get any marks.
Question 1
Issue SET PAGESIZE 200 at beginning of your session.
Display the (1) customer number, (2) customer name and (3) country cede for all the customers that are in the Belgium. The country code for Belgium is BE.
Please note that the user is to enter the 2 character country code AND that they can enter it as BE, be, bE and other combinations. Your SQL must allow for various user inputs of the code. They are not entering the country name.
QUESTION 3
For any customers that are called GO Outlets list the (1) customer number, (2) customer name and (3) order number if they ordered any of these products -- 40303, 40300, 40310, 40301, 40306. Put result in customer number order.
QUESTION 4
List the customer number, customer name and order number for customers that ordered products any of these 3 products 40310, 40303 and 60101. Only show customers with customer number more than 1140 Put result in order number with lowest first to highest order number.
QUESTION 5
Display all orders for United Kingdom. The word entered is United Kingdom and not UK.
Show only cities that start with L.
Display the (1) customer number, (2) customer name, (3) order number, (4) product name (5) the total dollars for that line on the order. Give that last column the name of SALES
Put the output into customer number order from highest to lowest.
Display only customer numbers less than 1000
QUESTION 6
DO NOT USE ALIAS NAMES for columns - remember need to show SQL and output to get any marks
Find the total dollar value for all orders from London. Each row will show (1) customer name; (2) order number and (3) total dollars for that order. Sort by highest total first
QUESTION 7
For all orders in the orders table supply order date and count of the number of orders on that date. Only include those in the year 2015 and have more than 1 order on that date.
QUESTION 8
Mr. King, the top person in the company, would like to see all orders in 2014 from United Kingdom and Canada. Show the (1) customer number, (2)customer name and (3)country name
QUESTION 9
The President wants to know out of the 150 to 155 customers that are on file, how many customers have not placed an order?
QUESTION 10
Show what customers ((1) number and (2) name) along with the (3) country name for all customers that are in the same countries as the Supra customers. Limit the list to any customer that starts with the letters A or B.