Question: *****provide any data model***** Use the Premiere script to create your SQL statements, then attach both SQL statements and query results. List the largest customer

*****provide any data model*****

Use the Premiere script to create your SQL statements, then attach both SQL statements and query results. List the largest customer balance, use alias, largest balance.

List the average part price, rounded to two decimal places, use alias, "average price."

List all part numbers, descriptions, and part prices (rounded to two decimal places) for parts priced between $30 and $300, inclusive.

Remove order numbers between 12491 and 12498, inclusive, in one statement?

Update all customers credit limits to $2000, for those customers whose balance is less than or equal to $800

Add three records to the order_line table, in one statement, with the following values: (12489, 'AZ52',10,24.99) (12491, 'AZ52',5,19.99) (12494, 'BA74',3,14.99)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!