ONUM AMT ODATE CNUM SNUM CITY 3001 18.69 03-OCT-14 2008 1007 London 3002 1900.1 03-OCT-14 2007...

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

This Query will select city and sumamt as money where am... View the full answer