Question: Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table: customer CNUM

Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to

Using table definition below write SQL statement(s) to record in the database selling product number Dw11 to customer number 148. (4) Table: customer CNUM Table: ORDERS ORDER NUM Table: orderline Table: part PART NUM AT94 21608 21610 21613 BV06 DL71 DR93 DW11 FD21 148 282 356 Ferguson's 842 All Season KV29 CNAME Al's Appliance and Sport Brookings Direct ORDER NUM PART NUM 21608 AT94 21610 DR93 ORDER_DATE 20/10/2007 20/10/2007 21/10/2007 DESCRIPTION Iron Home Gym Cordless Drill Gas Range Washer Stand Mixer Treadmill CNUM NUM ORDERED 11 1 148 356 408 CSTREET 2837 Greenway 3827 Devon 382 Wildwood 28 Lakeview QUOTED PRICE ON HAND 21.95 495 CLASS 50 HW 45 SG 21 HW 8 AP 12 AP 22 HW 9 SG CCITY Toronto ON Toronto ON Brampton ON Oakville ON CPROV PRICE 24.95 794.95 129.95 495 399.99 159.95 1390 CPCODE 33336 33321 33146 1111

Step by Step Solution

★★★★★

3.51 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Unfortunately there isnt enough context in your message to understand the question fully as it seems ... 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 Databases Questions!

(a) (b) Discuss the grounds under which a chief executive shall ipso facto cease to hold office of the chief executive. On 26 October 2022, the board of directors of Axis Cement Limited (ACL)...

BAYTARGE Ltd. ti. Manufactures XI and X2 type lamps. .Net profits of XI and X2 type lamps are 10 TL and 4 TL, respectively. Daily use of XI and X2 products as a result of market research It has been...

Given an economy with four goods: Eggs, Cotton Cloth, Yachts (fancy boats) and Apples with price elasticities of demand of -0.3, -2.5, -2.8 and -0.2 respectively, where Eggs and cotton cloth...

Using the Premier Products database answer the following questions Display the part information for order number 21610. Display the part number as Part Number, part description as Description, number...

Using the Premier_Products database, answer the following questions: 1. Which orders have more than 3 items of one part ordered? Display the order number, part number, and number ordered for these...

Using the Premier Products database answer the following questions 1. Using a union, display all customers that have rep number 65 or live in the town of Sheldon. Display all customer information....

Q 1 : Using table definition below write SQL statement to add yourself into the customer table. Assume that all fields require value. ( 1 ) Table: customer ( cnum , cname,cstreet,ccity,cprov,cpcode )...

Using the Premier Products database, answer the following questions: 1. Display all customers who have a credit limit less than $10,000 and have either sales rep 20 or rep 65. Display the customer...

Using the Premier Products database answer the following questions Display the rep name for each customer listed in the customer table. Display the customer number as Customer Number, customer name...

Please answer the following question using QBE. Thank you In the following exercises, you will use the data in the Premiere Product database. In each case, use QBE to obtain the desired results....

i always thumbs up Use the following information to answer the requirements below: Number of units sold Selling price per unit Variable selling expense per unit Variable administrative expense per...

In the mechanism shown in Fig. 2.53, the crank AB, 70 mm long, rotates clockwise at 110 rev/min. CD is 140 mm long. Link BD is 260 mm long and slides through a swivelling pin E at the lower end of...

At January 1 , 2 0 2 4 , Brant Cargo acquired equipment by issuing a four - year, $ 1 5 0 , 0 0 0 ( payable at maturity ) , 6 % note. The market rate of interest for notes of similar risk is 1 2 % ....

A simulation of a major traffic intersection is to be conducted, with the objectives of improving current traffic flow. Provide three iterations, in increasing order of complexity, of steps 1 and 2...

In which of the following situations a company needs to resort to the eDiscovery in an ECM system? Select one: a . The company needs to find the email addresses of its customers to send out the...

You run a restaurant, an event space and do catering for private events. You use a single, group-wide overhead allocation rate, with pricing at 145% of cost. You can make improvements by implementing...

The following represents the inventory of Rajan Company for the month of April: 6 The following represents the inventory of Rajan Company for the month of April Api 1 Beginning Inventory 100 units $8...

A sprinkler head malfunctions at midfield in an NFL football field. The puddle of water forms a circular pattern around the sprinkler head with a radius in yards that grows as a function of time, in...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...

What does it mean when a data warehouse is nonvolatile?

What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?

Dynamic random-access memory (DRAM) memory chips are made from silicon wafers in manufacturing facilities through a very complex process called wafer fabs. The wafers are routed through the fab...

Japolli Bakery tracks sales of its different bread products on a daily basis. The data for 22 consecutive days at one of its retail outlets in Nashville are in a file called Japolli Bakery ....

During the past few years, there has been a lot of discussion about the price of university textbooks. The complaints have come from many places, including students, faculty, parents, and even...