30 Apr CREATE THE SQL TO GENERATE A LISTING OF PRODUCT CODE AND DESCRIPTION OF PRODUCTS WHOSE LIST PRICE IS GREATER THAN $100 FOR VENDORS FROM TENNESSEE.
GROUP BY INVOICE.CUS_CODE, CUSTOMER.CUS_BALANCE;
4. Create the SQL to generate a listing of product code and description of products whose list price is greater than $100 for vendors from Tennessee. Include the name
and contact of the vendor.
5. Using an outer join, write a query to list the vendors who do not have any products listed in the inventory.
6. Create a customer directory that includes the customer code, the first, middle, and last name combined into one name column, and last four digits of the phone
number in a separate column as search index (“What are the last four digits of your phone number?”). Code your query so that if any of the customers name elements are
left null, the non-null portions of the name are still returned. Sort by the search index and present the results alphabetically. Here is a sample of the data set the
query should produce:
CustName SearchIndex
James G Brown 1228
Leona K Dunne 1238
Myron Orlando 1672
Paul F Olowski 2180
7. Calculate the inventory cost (quantity on hand * price) for each product. Round the result set to two decimal places. Return the inventory cost, product code and
description in order of inventory cost from highest cost to lowest. Additionally, skip the first 2 rows and then present the next 7 rows.
8. Write a query that returns the number of days that have passed since the current date and the date on which each product was received (P_INDATE). Include the
product code, description, vendor name and contact in your result set and order the result set by largest to smallest gap (between the current date and date received).
9. Write a query to create a list of invoices sorted by invoice date. Code the query so as to present only the date portion of the invoice date in your result set.
10. SQL String and Numeric Functions Workshop, #5.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.