1. List the title from the titles table, the order number and order date from the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. List the title from the titles table, the order number and order date from the sales table, and the store name from the stores table. Display only the first 30 characters of the title column. There should be a row produced in the result set for each row in the titles table. Order the result set by the order number. The query should produce the result set listed below. (Hint: LEFT OUTER JOIN statement) title Net Etiquette The Psychology of Computer Coo The Gourmet Microwave Straight Talk About Computers Bookshop Silicon Valley Gastronomic Tre Bookshop You Can Combat Computer Stress Bookshop (23 row(s) affected) ord_num stor_id stor_name P2121 P2121 ord_num TQ456 7896 423LL930 8042 P723 8042 NULL NULL 423LL922 (11 row(s) affected) Q02299 Fricative Bookshop Bookbeat Bookbeat TQ456 X999 7067 News & Brews 7067 News & Brews N914008 7131 Doc-U-Mat: Quality Laundry and Books ord_date NULL NULL 1994-09-14 00:00:00.000 1993-12-12 00:00:00.000 2. Using the INSERT command, add two books to the titles table. The first book has a title id of ZZ1234, title of Microsoft SQL Server, type of computer, publisher id of 0877, price of $89.99, and a publish date of September 29, 2008. The second book has a title id of TT2345, title of Designing Databases, type of computer, publisher id of 1389, priced of $168.98, and a publish date of January 1, 2009. 1993-10-28 00:00:00.000 Fricative 1993-02-21 00:00:00.000 3. List the sum of the order cost (quantity*price) for each order by store id, store name, order number, quantity, title, and price where the sum of the order cost is between $150.00 and $500.00. Display the order number, store id, and quantity from the sales table, the store name from the stores table, the price from the titles table, and the sum of the order cost. The query should produce the result set listed below. g|gzx_and 20 20 stor_name price NULL NULL Bookbeat 11.95 14.99 10.95 19.99 19.99 11.95 Fricative Fricative order_cost 239.00 299.80 219.00 199.90 199.90 298.75 4. Using the UPDATE command, increase the price by 10% for the book Microsoft SQL Server with a title id of ZZ1234. 5. Create a new table called BusinessBooks containing the title id, title, and price columns along with the data from the titles table which have a type of business. There should be 4 rows inserted into the new table. 1. List the title from the titles table, the order number and order date from the sales table, and the store name from the stores table. Display only the first 30 characters of the title column. There should be a row produced in the result set for each row in the titles table. Order the result set by the order number. The query should produce the result set listed below. (Hint: LEFT OUTER JOIN statement) title Net Etiquette The Psychology of Computer Coo The Gourmet Microwave Straight Talk About Computers Bookshop Silicon Valley Gastronomic Tre Bookshop You Can Combat Computer Stress Bookshop (23 row(s) affected) ord_num stor_id stor_name P2121 P2121 ord_num TQ456 7896 423LL930 8042 P723 8042 NULL NULL 423LL922 (11 row(s) affected) Q02299 Fricative Bookshop Bookbeat Bookbeat TQ456 X999 7067 News & Brews 7067 News & Brews N914008 7131 Doc-U-Mat: Quality Laundry and Books ord_date NULL NULL 1994-09-14 00:00:00.000 1993-12-12 00:00:00.000 2. Using the INSERT command, add two books to the titles table. The first book has a title id of ZZ1234, title of Microsoft SQL Server, type of computer, publisher id of 0877, price of $89.99, and a publish date of September 29, 2008. The second book has a title id of TT2345, title of Designing Databases, type of computer, publisher id of 1389, priced of $168.98, and a publish date of January 1, 2009. 1993-10-28 00:00:00.000 Fricative 1993-02-21 00:00:00.000 3. List the sum of the order cost (quantity*price) for each order by store id, store name, order number, quantity, title, and price where the sum of the order cost is between $150.00 and $500.00. Display the order number, store id, and quantity from the sales table, the store name from the stores table, the price from the titles table, and the sum of the order cost. The query should produce the result set listed below. g|gzx_and 20 20 stor_name price NULL NULL Bookbeat 11.95 14.99 10.95 19.99 19.99 11.95 Fricative Fricative order_cost 239.00 299.80 219.00 199.90 199.90 298.75 4. Using the UPDATE command, increase the price by 10% for the book Microsoft SQL Server with a title id of ZZ1234. 5. Create a new table called BusinessBooks containing the title id, title, and price columns along with the data from the titles table which have a type of business. There should be 4 rows inserted into the new table.
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
(1 point) If X and Y are independent and identically distributed exponential variables with parameter =5, compute each of the following joint densities. (a) U = 5X, V = 2X/Y. fu,v(u, v) = (b) U = 2X...
-
Direct Materials 500,000 Direct Materials Used 300,000 Raw Materials Used 500,000 Total Payroll 100,000 Indirect Labor 10,000 Other Factory Overhead 30,000 Overhead is applied based on 100% of Direct...
-
1. What is the relevance of effective and efficient use of I&T related resources; for transparency and accountability on the cost and value to the business of solutions and services? 2. Why should...
-
The Total Landed Costs (TLC) for a plastic wrap packaging machine from Germany to Monterrey, Mexico was calculated to be $723,566 USD. The company intends to use it for only 3 years and then resell...
-
Prove the three properties of the CDF in Theorem A.
-
Write a decimal number that has 5 in the thousands place, 0 in the tenths place, and 4 in the ten-thousandths place.
-
The 2015 annual report of the Procter & Gamble Company (P&G) is available at www.pginvestor.com. After reviewing P&Gs annual report, respond to the following questions: a. When does P&G recognize...
-
Raphael Restaurant is considering the purchase of a $9,000 souffl maker. The souffl maker has an economic life of five years and will be fully depreciated by the straight-line method. The machine...
-
Present this thesis about this topic (WILL ROBOTS TAKE OVER JOBS AND ELIMINATE THE NEED FOR HUMANS) and support that with clear arguments and reliable references. Topic: WILL ROBOTS TAKE OVER JOBS...
-
A headlight produced by Enterprise Lumiere was found to be defective. The company has three factories (labeled below as A. B, and C) where such headlights are manufactured. A Quality Control Manager...
-
Image transcription text Husky Peaches produces peach pie filling from three varieties of Peaches; Niagara, Georgia Sweet, and Pitless. Budgeted direct material quantities and costs to produce...
-
A 48 kg space probe orbits a newly discovered planet. Its orbital radius is 5.46x10 6 m and the mass of the planet is 2.23x10 24 kg. The space probe contains two devices- a mass attached to a spring...
-
Read the case information and writea2-3page paper in which you: choose any case: https://www.chronline.com/crime/ Summarize the facts of the case. Examine how the procedure would differ if the...
-
Teams are now used to produce goods and services, to manage projects, and to make decisions about running the company. by only a few O primarily by small O primarily by large by almost all O...
-
How has labor market policies affected marginalized communities? How would AOP help resolve this issues?
-
Explain using examples how you would objectively determine if an environmental education project was successful. Describe 2 indicators you could measure qualitatively and explain how you would...
-
The demand and supply for orange juice are described by: $3.3 = -1.6Qd + 8.5 and $3.3 = 0.9Qs + 1.5 Calculate the surplus or shortage and enter the answer using 1 decimal place.
-
Find the APR in each of the following cases: NUMBER OF TIMES COMPOUNDED Semiannually Monthly Weekly Infinite EAR APR 10.4% 8.9 11.6 15.4
-
Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2012. The truck is not considered a passenger automobile for purposes of the listed property...
-
Mallory Corporation has a calendar year-end. The corporation has paid estimated payments of $10,000 during 2012 but still owes an additional $5,000 for its 2012 tax year. a. When is the 2012 tax...
-
Ulysses and Penelope are married and file separate returns for 2012. Penelope itemizes her deductions on her return. Ulysses' adjusted gross income was $17,400, his itemized deductions were $2,250,...
-
Financial Statement Analysis Limitations Which of the following is not considered a limitation of financial statement analysis? a. Firms may use different accounting methods. b. Firms may be audited...
-
Refer to the income statement data given in Exercise E13-3A. a. Prepare common-size income statements for each year. b. Compare the common-size income statements and comment briefly. Exercise E13-3A....
-
The following information is available for Jay Company: Calculate the following ratios for 2019: a. Gross profit percentage b. Return on sales c. Asset turnover d. Return on assets e. Return on...
Study smarter with the SolutionInn App