dbms

Questions & Answers

Question 37433

Verified

DBMS

(8) List the swimmers (names and their number of participated events) who have participated in two or more '100M' events (events with '100M' in their titles) in the following format. Note the order of the result is in descending of the counts of 100Mevent participations.

Turn in CSCI4333_<<Section #>>_H6_<<Your name>>_<<Your StudentID>>.sql.txt and submit your homework through Blackboard. It must be done in text format executable by the TA using the source command.

Question 37432

Verified

DBMS

(7) List the names of all swimmers and their number of wins (the number of times with the word Winner in the result in an event) in the following format.

Question 37431

Verified

DBMS

(6) List the numbers of events on distances. Assume that the event title uses the format of "<distance>M <style>", e.g. "50M Butterfly". Note the order of the result is in ascending distance.

Question 37430

Verified

DBMS

(5) List the names of swimmers who have participated in meet #1 but not meet#3.

Question 37429

Verified

DBMS

(4) List the names of the swimmers who have participated in both event #1 and event #9.

Question 37428

Verified

DBMS

(3) ) List all swimmers (their names, levels) event titles, and meet titles in which the swimmers have participated in a Freestyle event of the meet.

Question 37427

Verified

DBMS

(2) List the names of the swimmers who has the same last name as their primary care takers.

Question 37426

Verified

DBMS

(1) List the names, phones and join times of all swimmers joining in the years of2014 to 2017.

No Search results found!

Kindly submit your queries
we will make sure available to you as soon as possible.

Search Other Question


Submit query

Getting answers to your urgent problems is simple. Submit your query in the given box and get answers Instantly.

Submit a new Query

Please Add files or description to proceed

Success

Assignment is successfully created

News & Offers


  • Offers
  • Flash sale on now! Get 20% off until 25th June, online at TutorBin. Use discount code ALK&8JH at Tutorbin.com/Booking
  • News
  • Latest Blog Published:
    [Blog Name], online at [Time]
  • News
  • Latest Blog Published:
    [Blog Name], online at [Time]