Question: Refer the given table and answer the question that follow: TABLE PRODUCT Pro_ID P1220 P1222 P1223 P1224 Pro_Name BUTTER MILK MUFFINS CAKE Category DAIRY

Refer the given table and answer the question that follow: TABLE PRODUCT Pro_ID P1220 P1222 P1223 P1224

Refer the given table and answer the question that follow: TABLE PRODUCT Pro_ID P1220 P1222 P1223 P1224 Pro_Name BUTTER MILK MUFFINS CAKE Category DAIRY DAIRY BREAD BREAD Price 50.555 20.500 35.750 25.255 Sup_ID S1024 $1024 S2012 S2055 a. Write an SQL Query to display Product ID first 3 letters from the Product Name for the products with category DIARY and BREAD. (2.5 Marks) b. Write an SQL Query to calculate and display PRODUCT NAME PRICE after multiplying the price by 2 with an alias name NEWPRICE for those products where the name starts with letter M and Price more than 30. (2.5 Marks) c. Write an SQL Query to display unique Categories, round the price to 2 decimal places and display it in the ascending order of Price. (2.5 Marks) d. Write an SQL query to display Category in small letters, highest price for each category of products. (2.5 Marks)

Step by Step Solution

★★★★★

3.36 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a SQL Query to display Product ID first 3 letters from the Product Name for the products with catego... View full answer

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 Computer Network Questions!

The following information pertains to Amazon Co.'s defined benefit pension plan for 2023: Projected benefit obligation on Jan. 1, 2023.......... Interest income earned by the Pension Fund assets...

On the topic: Being Super-Reasonable: Explain this term in your own words. Give a personal example of being passive aggressive. Find a quotation from the textbook, How To Improve Your Interpersonal...

At present, assuming a company focuses on maximizing shareholder wealth as its major goal. The managing director thinks this single goal is inappropriate and asks his co-directors for their views on...

Dr. Daniela Yeung, a health psychologist, has been conducting a federally funded ethnographic study of couples in which the male partner has been imprisoned for intimate partner violence. Over the...

what scenarios is thread-local storage beneficial, and how does it compare to other state-sharing techniques in terms of efficiency and maintainability ?

Read the "H-E-B Own Brands" case and answer the questions below. Please state clearly your computations and your assumptions, and keep a copy to refer to during our discussion. How should Own Brands...

Refer the given tables and answer the question that follow: Table: PURCHASE DETAILS ORDER_NO PRODUCT_NAME 1001 KEYBOARD PRICE QUANTITY 100 56 1002 MONITOR 36 200 1003 MOUSE 6 100 1004 58 300 HARD...

Refer the given tables and answer the question that follow: PRICE QUANTITY 100 56 36 Table: PURCHASE DETAILS ORDER NO PRODUCT NAME 1001 KEYBOARD 1002 MONITOR 1003 MOUSE 1004 HARD DISK 1005 RAM 1007...

Refer the given tables and answer the question that follow: Table: PURCHASE DETAILS ORDER_NO PRODUCT_NAME 1001 KEYBOARD PRICE QUANTITY 56 100 1002 MONITOR 36 200 1003 MOUSE 6 100 1004 58 300 HARD...

Refer the given tables and answer the question that follow: Table : PURCHASE ORDER ORDER NO AMOUNT ORDER DATE CUSTOMER ID SALESMAN DELIVERY DATE NAME 1001 300 2001 05-03-2017 10-07-2017 1002 AJI...

In applying the lower-of-cost-or-market method to inventories, inventory values are written down when replacement cost falls. If the replacement cost then increases, inventory values are written up,...

Identify the two major differences between service and manufacturing organizations. Find an example of a service and manufacturing company and compare them.

Question 1 0 of 4 0 ( required ) You have observed an individual commit an indictable offence on the property, you are actively pursuing the individual they then exit the property. Are you able to...

A study is to be conducted of the percentage of homeowners who own at least two television sets. How large a sample is required if we wish to be 99% confident that the error in estimating this...

Classification of Acquisition Costs Selected accounts included in the property, plant, and equipment section of Lobo Corporations balance sheet at December 31, 2009, had the following balances. Land...

Ron Williams recently took over as the controller of Johnson Brothers Manufacturing. Last month, the previous controller left the company with little notice and left the accounting records in...

A mobile is formed by supporting four metal butterflies of equal mass m from a string of length L. The points of support are evenly spaced a distance apart as shown in Figure P5.73. The string forms...

Account analysis Java Joe Coffees wants to find an equation to estimate monthly utility costs. Java Joes has been in business for one year and has collected the following cost data for utilities:...

In a primary email the body of the message contains all of the content, true or false

In the Social and Natural Sciences Journal (Vol. 6, 2012), the time x (in minutes) between two successive arrivals of buses was modeled using an exponential distribution with mean ( = 3.77. a. Give...

The complete model E(y) = 0 + 1x1 + 2x2 + 3x3 + 4x4 + was fitted to n = 20 data points, with SSE = 152.66. The independent variables x3 and x4 were dropped from the model, yielding SSE = 160.44. a....

What are the factors that allow a native Spanish-speaking person to understand and read English? A study published in the Bilingual Research Journal (Summer 2006) investigated the relationship of...

The Miltmore Corporation performs consulting services for companies that think they have image problems. Recently, the Bluedot Beer Company approached Miltmore. Bluedot executives were concerned that...

A Vermont company is monitoring a process that fills maple syrup bottles. When the process is filling correctly, the median average fill in an 8-ounce bottle of syrup is 8.03 ounces. The last 15...

The manager of credit card operations for a small regional bank has determined that last years median credit card balance was $1,989.32. A sample of 18 customer balances this year revealed the...