Answered step by step
Verified Expert Solution
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 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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started