1.SELECT fName,lName FROM conductor order by fname;.

Added on - 16 Sep 2019

  • 2

    Pages

  • 275

    Words

  • 331

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
1.SELECT fName,lName FROM conductor order by fname;2. SELECT concert.title, concert.date, concert.ticketPrice, conductor.fnameFROM concert inner join conductor onconcert.conductorEmployeeId=conductor.conductorEmployeeId;3. SELECT consertMusician.instrumentId, instrument.instrumentName fromconsertMusician inner join instrument onconsertMusician.instrumentId=instrument.instrumentId group byconsertMusician.instrumentId order by count(consertMusician.instrumentId)desc limit 1;4. SELECT fName, lName FROM conductor WHEREconductorEmployeeId NOT IN (SELECT musicianEmployeeId FROMconsertMusician);5. SELECT conductor.fName, conductor.lName FROM concert inner joinconsertMusician onconcert.conductorEmployeeId=consertMusician.musicianEmployeeId andconcert.concertId=consertMusician.consertId inner join conductor onconcert.conductorEmployeeId=conductor.conductorEmployeeId;6. SELECT instrument.instrumentName, count(employee.employeeID) ascountEmployee from employee inner join instrument onemployee.instrumentId=instrument.instrumentId group byemployee.instrumentId;7,CREATE VIEW allData ASSELECT AVG(concert.ticketPrice) asavgTicketPrice, COUNT(consertMusician.musicianEmployeeId) ascountConcert, musician.fName, musician.lName FROM consertMusicianinner join concert on consertMusician.consertId=concert.concertId innerjoin musician onconsertMusician.musicianEmployeeId=musician.musicianEmployeeIdGROUP BY consertMusician.musicianEmployeeId HAVING countConcert> 1;
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document