Scribd
Upload
69 views1 page

ITC556 SQL: Week 9 Activities (Set 2)

This document provides a set of SQL problems and exercises related to querying a database called Thirlemere Thoroughbreds. There are 10 problems that require joining tables, filtering results, sorting output, and aggregating data to list event details, horse placements, prize money, and judge/show information for queries on the database. The problems cover basic to more advanced SQL skills like multiple table joins, sorting, aggregation, and filtering criteria.

Uploaded by

Ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
69 views1 page

ITC556 SQL: Week 9 Activities (Set 2)

This document provides a set of SQL problems and exercises related to querying a database called Thirlemere Thoroughbreds. There are 10 problems that require joining tables, filtering results, sorting output, and aggregating data to list event details, horse placements, prize money, and judge/show information for queries on the database. The problems cover basic to more advanced SQL skills like multiple table joins, sorting, aggregation, and filtering criteria.

Uploaded by

Ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

ITC556

SQL
Week 9 Activities (set 2)

Section-2
All the following problems use the Thirlemere Thoroughbreds (TT)
database. Before you answer any of these, you will need to load that
database.
2.1 List the event_id and event_name for each event, together with the
name of the judge who is judging it. (hint - join the event and judge
tables)
2.2 List the name of each horse who has been awarded a first place.
2.2A Modify your query so you do not display the name of a horse more than
once.

2.3 For each event that a horse has entered. List the name of the horse
together with the name of the event, and its placing in that event (if
any).
2.4 For each event, list the name of the event, the name and address of
the show that it is in, and the name and address of the judge who is
judging it.
2.5 For all events at the show named “Dubbo”, list the date of the show,
the judge name and the event name.
2.6 For each event with a first prize, list the event name and the first
prize money.
2.7 List event_id, horse_id, place and money. Sort the results into order
on event_id then horse_id.
2.8 For each event with a first prize, list the show name, event name and
first prize money.
2.9 List the horse name, show name, event name and place for all horses
in events judged by “Green”.
2.10 List the event_id and event name for all events entered by Star or
Flash and judged by Smith from Melbourne.

You might also like