Home
Main topics
Study help discussion
All study help
GCSEs
A-level
University discussion
Uni applications
University and HE colleges
University help and courses
University student life
Postgraduate
Medicine
Careers discussion
Careers and jobs
Teacher training
Finance and accountancy
Lifestyle discussion
Chat
Relationships
Fashion
Fitness
Sexual health
GCSE and A-level
Study level discussion
GCSE
A-level
Btec
T-level
Scottish qualifications
IB
EPQ
Study help discussion (by subject)
Maths
English
Geography
History
Biology
Chemistry
Physics
Foreign languages
All study help
GCSE and A-level articles
GCSE articles
A-level articles
Exam and revision articles
What to do after GCSEs
What to do after A-levels
When is A-level results day 2024?
When is GCSE results day 2024?
More study help
Studying, revision and exam support
Grow your Grades
Revision and exams
Revision and exam discussion
A-levels
GCSEs
Btecs
All A-level exams
All GCSE exams
Revision tips
Top vloggers for revision help
Best video resources for revising GCSE or A-level English
Best places online for maths revision
How to use past exam papers for revision
Preparing for an exam
How to study effectively for your exams
Handling revision and exam stress
What to expect from an exam
Seven things to do in the last week before an exam
How to handle exam nightmares
Finding motivation
Getting past procrastination
It's not too late: 10 ways to kick-start your revision
How to revise when you're feeling lazy
University
University discussion
All universities
Applying through Ucas
Student finance
Personal statement
Postgraduate study
Uni accommodation
University life
University course discussion
All uni courses
Apprenticeships
Medicine
Arts and humanities courses
Stem courses
Social science courses
Universities by region
North of England
Midlands
South of England
Greater London
Scotland
Wales
Northern Ireland
Distance learning
International study
University guides and articles
All university articles
Applying to uni articles
Personal statements
Personal statement examples
Freshers
University open days
Studying law at university
Student life at university
Careers and jobs
Careers discussion
Careers and jobs discussion
Apprenticeships discussion
Part-time and temp jobs
Industry forums
Career forums by sector
Armed forces careers
Consultancy careers
Finance careers
Legal careers
More industry forums
Marketing careers
Medicine and healthcare careers
Public sector careers
Stem careers
Teaching careers
Life and relationships
Life chat
General chat
Relationships
Friends, family and colleagues
Advice on everyday issues
Fashion
Health chat
Life and style
General health
Sexual health
Mental health
Fitness
News and entertainment chat
Debate and current affairs
Entertainment
UK politics
News
Educational debate
Football
Sport
Student finance
Undergraduate
Full time
Part time
Postgraduate
Postgraduate Master's Loan
Postgraduate Doctoral Loan
Disabled Students' Allowances
Taking a break or withdrawing from your course
Further information
Parents and partners
Repayment
Advanced Learner Loan

What would you like to say?

Your discussion will live here...

(Start typing, we will pick a forum for you)

Year 12s: what will be the first way you research your future options? >>

Take our quiz to find out what your revision personality is! >>

Year 12s: what will be the first way you research your future options? >>

Take our quiz to find out what your revision personality is! >>

Forums
BTEC IT Database Exam May 2019

BTEC IT Database Exam May 2019

Domw112233

"a query to display the number of seats remaining for each event. It should show the event description, total adult seats sold, total child seats sold and the total number of seats remaining"

Does anybody know how to do this?

Reply 1

LewisC0505

I need help with this too

Reply 2

Richard_cook

what did anyone get for the actual tables? and has anyone done the purchases table for the exam yet

Quick Reply

Related discussions

BTEC IT Unit 2 January 2024 exam discussion
Btec it level 3 unit 2
BTEC IT Level 3 Unit 2 Exam Discussion
Btec IT
Failed Btec Unit
Unit 2 creating systems to manage information
Data science bsc at LSE? (experience, advice)
Btec Grade Boundaries
24th January 2022 BTEC IT Level 3 Unit 1 (Information Technology Systems)
BTEC IT Level 3 Unit 2 Exam Discussion
BTEC IT level 3 unit 11 Cyber Security
Urban Planning - Unsure of options
Btec applied science unit 5 January 2024
Is it true that BTEC’s struggle at university?
GCSE remark
What will A-level, GCSE and Vocational Qualifcations look like in 2023
Btec ICT level 3 (information technology) unit 2
Student loans
ELQ exemption funding?
How to Prepare for Level 3 Applied Science?

Latest

Articles for you

Can you get into university if you’re studying Btecs?

What are Btecs? A quick guide to Btec qualifications

Can you do a Btec and A-levels at the same time?

Btec results day 2024: what to expect

The Student Room and The Uni Guide are both part of The Student Room Group.

Get Started

Today's posts
Unanswered posts
Community guidelines

Using TSR

TSR help centre
Cookies & online safety
Terms & conditions
Privacy policy
Ad Privacy Settings

Info

About TSR
Advertise
Contact us

Connect with TSR

Twitter
Facebook
YouTube
Instagram
TikTok

The Student Room and The Uni Guide are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: Imperial House, 2nd Floor, 40-42 Queens Road, Brighton, East Sussex, BN1 3XB