Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How many rows will contain the output of the following query? SELECT snum, SUM(amt) as Money FROM orders WHERE amt>5000 GROUP BY snum; ONUM

How many rows will contain the output of the following query? SELECT snum, SUM(amt) as Money FROM orders ONUM AMT 3001 18.69 3002 1900.1 3003 767.19 3005 5160.45 3006 1098.16 3007 75.75 3008 4723 3009 1713.23 3010

How many rows will contain the output of the following query? SELECT snum, SUM(amt) as Money FROM orders WHERE amt>5000 GROUP BY snum; ONUM AMT 3001 18.69 3002 1900.1 3003 767.19 3005 5160.45 3006 1098.16 3007 75.75 3008 4723 3009 1713.23 3010 1309.95 ODATE CNUM SNUM 03-OCT-14 2008 1007 London 03-OCT-14 2007 1004 London 03-OCT-14 03-OCT-14 2003 1002 London 03-OCT-14 2008 1007 Madrid 04-OCT-14 2004 1002 London 05-OCT-14 2006 1002 London London London CITY 2001 1001 Barcelona 04-OCT-14 2002 1003 06-OCT-14 2004 1002 3011 9891.88 06-OCT-14 2006 1001 Barcelona Orders How many rows will contain the output of the following query? SELECT snum, SUM(amt) as Money FROM orders WHERE amt>5000 GROUP BY snum; ONUM AMT 3001 18.69 3002 1900.1 3003 767.19 3005 5160.45 3006 1098.16 3007 75.75 3008 4723 3009 1713.23 3010 1309.95 ODATE CNUM SNUM 03-OCT-14 2008 1007 London 03-OCT-14 2007 1004 London 03-OCT-14 03-OCT-14 2003 1002 London 03-OCT-14 2008 1007 Madrid 04-OCT-14 2004 1002 London 05-OCT-14 2006 1002 London London London CITY 2001 1001 Barcelona 04-OCT-14 2002 1003 06-OCT-14 2004 1002 3011 9891.88 06-OCT-14 2006 1001 Barcelona Orders

Step by Step Solution

There are 3 Steps involved in it

Step: 1

The query will select all the orders with the amount greater tha... 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

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Programming questions

Question

5. How is Mr. Bonner encouraging Marcuss self-efficacy?

Answered: 1 week ago