I am using SQL and I need a code that will give me this output. You can use the

Question

I am using SQL and I need a code that will give me this output. You can use the names of the columns and rows on these tables to write the code. I just don't know how to write them. Please SQL. Thank you :)

The table definitions are as follows...

Q.1) (15 points Write a query that replicates the result set below, matching all data and format aspects, including column headers: Search Export: Result Grid EE Filter Rows: product code product name discount percent price after discount price Sg Gibson SG 1,208.16 2,517.00 52.0 les paul Gibson Les Paul 1,199.00 30.0% 839.30 Tama 5-Piece Drum Set with Cymbals $799.99 15.00 679.99 tama. precision Fender Precision 799.99 30.0 559.99 ludwig Ludwig 5-piece Drum Set with Cymbals 699.99 30.0 489.99 Fender Stratocaster 699.00 30.0 489.30 strat Hofner Icon 374.99 hofner 499.99 25.0 fg700s 489.99 38.0% 303.79 Yamaha FG700S rodriguez Rodriguez Caballero 11 415.00 39.0% 253.15 washburn Washburn D10s 299.00 0.0% 299.00 Q.2) (15 points Write a query that replicates the result set below, matching all data and format aspects, including column headers: Result Grid Filter Rows: a Search Customer Name Email Address Sherwood, Allan

Explanation / Answer

Q2) select first_name+','+last_name as Customer_Name,email_address as Email_Address from customers;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.