Question

[6]
a. Consider the table Activity given below and write the sql commands
Activity
acode
aname
Venue
noparticipants
doe
prize
4
A01
Dance
Mainhall
10
23-01-17
10000
A02
Percussion
Avhall
16
22-01-17
10000
A03
Drums
Musicroo
12
20-01-17
20000
m
A04
Music
Mainhall
15
24-01-17
12000
A05
painting
Artroom
12
28-01-17
8000
i) to display the details of all activities which are conducted in mainhall
and having prize more than 10000
ii) to display the details of activities which has number of participants
between 10 and 15
ill) to display the activityname, venue name and prize money of all
activities which are conducted on Thursday
iv)to display the number of participants in each event for which the prize
money is less than 15000
v)to display the venue along with number of participantsfor all the items
whose activity name has more than 4 characters and activity code less than​

Answer 1

Answer:

dgzgugxxx gkkkkjjjjchl