Your manager requires you to create an SQL query that will display the combined customer name, the townhouse number, materials used and the purchase agreement amount. In your query, only display the...


Your manager requires you to create an SQL query that will display the combined customer name,<br>the townhouse number, materials used and the purchase agreement amount. In your query, only<br>display the purchase agreement amounts greater than R1 100 000.<br>Sample Results<br>CUSTOMER<br>HOUSE_NUM MATERIALS<br>PURCHASE_AMOUNT<br>Wayne,<br>3<br>Roman Standard Roofing, Oak<br>R1 120 000<br>Bitterhout<br>Doors, Luxury Garage Doors,<br>Italian Style Tiling, Mizu Bath,<br>Tri Glider Shower, Stella Staps<br>Luxury Standard Roofing,<br>Thando, Zolani<br>2<br>R1 190 000<br>Luxury Door, Luxury Garage<br>Door, Luxury Style Tiling, Luxury<br>Bath, Luxury Glider Shower,<br>Luxury Staps<br>

Extracted text: Your manager requires you to create an SQL query that will display the combined customer name, the townhouse number, materials used and the purchase agreement amount. In your query, only display the purchase agreement amounts greater than R1 100 000. Sample Results CUSTOMER HOUSE_NUM MATERIALS PURCHASE_AMOUNT Wayne, 3 Roman Standard Roofing, Oak R1 120 000 Bitterhout Doors, Luxury Garage Doors, Italian Style Tiling, Mizu Bath, Tri Glider Shower, Stella Staps Luxury Standard Roofing, Thando, Zolani 2 R1 190 000 Luxury Door, Luxury Garage Door, Luxury Style Tiling, Luxury Bath, Luxury Glider Shower, Luxury Staps

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here