Question: 1. [Write SQL statement for the following:] List the Customer Names who order goods which are between Item Number 1600 and Item Number 4000 and

1. [Write SQL statement for the following:] List

1. [Write SQL statement for the following:] List the Customer Names who order goods which are between Item Number 1600 and Item Number 4000 and who's total due is not more than 500 [5 marks] * 40 Inventory Item_No Item_Description Unit_Price Quantity 1537 SHORTS 12 186 1609 JACKET 25 2719 T-SHART 10 24 3512 TENNIS-SHORT 19 35 3804 TENNIS-SHIRT 18 118 4205 SOCKS 4 160 5172 SWEATSHIRT 225 5173 SWEATPANT 15 822 5501 CAP 7 90 6318 SWIMSUIT 22 52 Order Customer_Number Item_Number Quantity 48721 2719 8 48721 5501 6 29636 3804 5 12345 1537 10 12345 2719 12 12345 3804 18 51387 2719 2 51387 5501 4 19 Billing Customer_Number Customer_Name Total_Due 12345 CAMPUS SPORT SHOP 547 29636 CITY SPORTS 88 34074 SMITH SPORT SHOP 10 48721 JOE SPORTS 122 51387 ABC SPORTING GOODS 49

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Scenario A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her...

Create a report, sales account receivables, receivables reconciliation (summary). Transaction Sources Cash registers - for cash sales Invoices for credit sales Cheque book for cash payments Deposit...

Create a general ledger (account) Balance sheet and Profit & loss statement. Transaction Sources Cash registers - for cash sales Invoices for credit sales Cheque book for cash payments Deposit books...

create a purchases, payable reconciliation summary. report^ Transaction Sources Cash registers - for cash sales Invoices -- for credit sales Cheque book - for cash payments Deposit books - for cash...

Create a sales account receivables and receivables reconciliation (summary). Only for Customers, Suppliers and Inventory. Thanks :) Transaction Sources Cash registers - for cash sales Invoices - for...

Assignment 3 Instructions Create a database in SQLServer for the relational model provided in the HW3- Relational Schema file. Populate your database with some data to test your database. Write the...

Hello, Please could you help me with this question and also with my homework? Thanks in advance. The first question is below and the homework is attached (uploaded). Warble Inc. extended a one-year...

Question: 4 (25 marks) Consider a "Customer Order processing database with three tables as given below 1.Customer - captures customer details cust_no 0001 C002 C003 C004 cust_name John Joseph Peter...

Open the MySQL Workbench, and use File - - > Run SQL script. Navigate to this file on your computer and execute this file. See demonstration from class recording Answer the following questions using...

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

What do you think are the factors that contribute to the gender pay gap? What are some possible ways to remedy the gender pay gap? Do you believe that the gender pay gap will ever be eliminated?

Which of the following is true about standard costing? The purpose of standard costing is to replace budgets and budgeting The purpose of standard costing is to simplify costing procedures A purpose...

? _ _ _ _ _ _ _ _ _ _ _ _ _ _ a c c e p t d e p o s i t s f r o m i n d i v i d u a l s a n d t h e n l e n d p o o l e d d e p o s i t s t o b u s i n e s s e s , g o v e r n m e n t s , a n d i n d...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....