How many rows will contain the output of the following query? SELECT snum, SUM(amt) as Money...

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

The query will select all the orders with the amount greater tha... View the full answer