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...
-
In Problem, graph f, locate all points of discontinuity, and discuss the behavior of f at these points. if x 0 f(x) = 0 1+x ifx = 0 if x >0
-
Sheaves Corporation economists estimate that a good business environment and a bad business environment are equally likely for the coming year. Management must choose between two mutually exclusive...
-
discuss the fundamental attribution error and its impact on perceptions;
-
The adjusted trial balance for Burlington Advertising Services is presented below: Requirements 1. Prepare the income statement for the year ending December 31, 2016. 2. Prepare the statement of...
-
Connectix Inc. recently issued noncallable bonds that mature in 10 years. They have a par value of $1,000 and an annual coupon of 7.5%. If the current market interest rate is 7.7%, at what price...
-
10 A student works the following problem and then stops Explain what is wrong with the problem 6 cos x 2 1 cos x cos x 3 1 V 3 1 ANSWER 1
-
How do advanced materials and nanotechnology contribute to the development of next-generation renewable energy technologies, such as high-efficiency solar cells, advanced wind turbine blades, and...
-
what excel formula is used to solve the question. Newtown wants to accumulate money for a new library. The building is estimated to cost $1,000,000 today. Construction inflation is 4%. What will the...
-
Give An introductory paragraph that identifiesDiLonard's thesis (using own words as far as possible). This can consist of a few short sentences, or a single all-encompassing sentence that...
-
How do various credit scoring models, like FICO and VantageScore, impact the approval process for mortgage loans, and what is the significance of credit risk in determining interest rates and other...
-
Discuss briefly the consideratings required in order to determine whether a trade-related mode of entry or an investment mode of entry should be used. Use your various external and internal analysis...
-
Problem 10-6A (Algo) Disposal of plant assets LO C1, P1, P2 [The following information applies to the questions displayed below.) Onslow Company purchased a used machine for $240,000 cash on January...
-
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,...
-
The data below are selected accounts from the adjusted trial balance of Dans Sports Equipment, Inc., on September 30, 20x6, the fiscal year end. The companys beginning merchandise inventory was...
-
Tonia Company engaged in the following transactions in July 20xx: July 1 Sold merchandise to Su Long on credit, terms n/30, FOB shipping point, $4,200 (cost, $2,520). 3 Purchased merchandise on...
-
Industrial Services Company provides maintenance services to factories in the West Bend, Wisconsin, area. The company, which buys a large amount of cleaning supplies, consistently has been over...
Study smarter with the SolutionInn App