This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	AI (Artificial Intelligence) (21 exercises)
Topic ==>	Coding - SQL (2 exercises)
Level ==>	Average difficulty
Subject ==>	Artificial Intelligence training

Create a query showing statistics for a world events database

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Before you can do this exercise, you'll need to download and unzip this file .

In SQL Server Management Studio open the query given in the above folder, and run it to generate a database called WorldEvents. This lists out the country and category for some important events which have happened in (fairly) recent world history.

Generate script defining the tables, columns and relationships in this database, then include this within a prompt in your favourite AI tool to create a SQL query listing out:countries in alphabetical order with:

the number of events which occurred in the 1990s in each; and
the number of events which occurred in either the Religion or the Education category in each (regardless of year).

Run this generated SQL in your database. If all goes well you should see something like this:

Here we've sneakily reversed the country name sort order before running the query so that you can see the more "interesting" countries first (ie those for which there are non-zero numbers in both columns)..

Finally, ask your AI tool to critique this query to see if it could be improved (you'll probably find that its performance can be tweaked a tiny bit with some optimisation, but you also probably won't care much about these tiny changes!).

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.

You can find other training resources for the subject of this exercise here: