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

Added on - 16 Sep 2019

  • 2

    pages

  • 275

    words

  • 101

    views

  • 0

    downloads

Showing pages 1 of 2
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;