Scribd
Upload
70 views2 pages

Programming Worksheet 7

This document provides SQL queries and tasks to select and sort data from two tables: tblPupil and tblEvent. The tasks include writing queries to select columns based on certain criteria like date of birth or event category and name. It also involves listing the results of queries and writing a statement to sort one of the tables by an ascending field.

Uploaded by

potholemary
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
70 views2 pages

Programming Worksheet 7

This document provides SQL queries and tasks to select and sort data from two tables: tblPupil and tblEvent. The tasks include writing queries to select columns based on certain criteria like date of birth or event category and name. It also involves listing the results of queries and writing a statement to sort one of the tables by an ascending field.

Uploaded by

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

Worksheet 7 Introduction to SQL

Unit 6 Programming

Worksheet 7: Introduction to SQL


Task 1:

Two tables, tblEvent and tblPupil, are shown below.

1. Write SQL statements to:


(a) select the “Firstname”, “Surname” and “DateOfBirth” columns from tblPupil.
_________________________________________________________

__________________________________________________________________

(b) select the “EventCategory” and “EventName” columns from tblEvent for which new
school records were set.
__________________________________________________________________

__________________________________________________________________

__________________________________________________________________

(c) select all columns from tblPupil for pupils in Darwin, Faraday or Bell.
__________________________________________________________________

__________________________________________________________________

__________________________________________________________________

1
Worksheet 7 Introduction to SQL
Unit 6 Programming

(d) select all columns from tblEvent for which for which the Event category is Year 7 girls
and the event name is either 60m or 60m Hurdles.

_________________________________________________________________

_________________________________________________________________

_________________________________________________________________

_________________________________________________________________

2. List the results of executing the following SQL queries on the database.

(a) SELECT FirstName, Surname, DateOfBirth


FROM tblPupil
WHERE DateOfBirth BETWEEN 01/01/2004 AND 31/12/2004

_________________________________________________________________

_________________________________________________________________

_________________________________________________________________

(b) SELECT EventCategory, EventName


FROM tblEvent
WHERE EventCategory = ‘Long Jump’ AND NewSchoolRecord = Yes

_________________________________________________________________

_________________________________________________________________

Task 2:

3. Write an SQL statement to sort tblEvents into ascending order by EventCategory,


displaying only the fields EventCategory, EventName and WinnerID.

_________________________________________________________________

_________________________________________________________________

_________________________________________________________________

You might also like