Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following 3 tables below Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5. Chris 34 40000 7

image text in transcribed
image text in transcribed
Consider the following 3 tables below Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5. Chris 34 40000 7 Dani 41 52000 8 Ken 57 115000 11 Joe 38 38000 ID Name City Industry Type 4 Samsonic pleasant 6 Papasnog leaktowa 2 Samany lackan. B 9 Orange Jackson B Orders Number order date custid.salespeonid Amount 10 8/2/96 4 2 540 20 1/30/99 4 8 1800 30 7/14/95 9 1 460 40 1/29/98 7 2 2400 50 2/3/98 6 7 600 60 3/2/98 6 7 720 20 5/6/98 9 150 b) Write SQL query to sort the orders table by Order date ascending first and then by amount descending Write SQL query in the box below (Text Format Only) (2 marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

More Books

Students also viewed these Databases questions