Using the database you created (“animal name”) for your labs…
Using the database you created (“animal name”) for your labs, construct a sql statement to review the history of the loads you have performed. (data you loaded into your database) Include in the select statement: Schema Name, File name, table name, last load time and status. Limit the output to show just 10 records. (supply the sql only – not the output)
Read DetailsUsing the same query in the first select statement, modify i…
Using the same query in the first select statement, modify it to only return APAC and EUROPE regions and then group the data by supplier name, account balance, region name and nation name and order the data by account balance in descending order. (supply the sql only – not the output)
Read Details