Ask a question from expert

Ask now

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

2 Pages275 Words475 Views
   

Added on  2019-09-16

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

   Added on 2019-09-16

BookmarkShareRelated Documents
1.SELECT fName,lName FROM conductor order by fname;2. SELECT concert.title, concert.date, concert.ticketPrice, conductor.fnameFROM concert inner join conductor on concert.conductorEmployeeId=conductor.conductorEmployeeId;3. SELECT consertMusician.instrumentId, instrument.instrumentName fromconsertMusician inner join instrument on consertMusician.instrumentId=instrument.instrumentId group by consertMusician.instrumentId order by count(consertMusician.instrumentId)desc limit 1;4. SELECT fName, lName FROM conductor WHERE conductorEmployeeId NOT IN (SELECT musicianEmployeeId FROM consertMusician);5. SELECT conductor.fName, conductor.lName FROM concert inner join consertMusician on concert.conductorEmployeeId=consertMusician.musicianEmployeeId and concert.concertId=consertMusician.consertId inner join conductor on concert.conductorEmployeeId=conductor.conductorEmployeeId;6. SELECT instrument.instrumentName, count(employee.employeeID) as countEmployee from employee inner join instrument on employee.instrumentId=instrument.instrumentId group by employee.instrumentId;7, CREATE VIEW allData AS SELECT AVG(concert.ticketPrice) as avgTicketPrice, COUNT(consertMusician.musicianEmployeeId) as countConcert, musician.fName, musician.lName FROM consertMusician inner join concert on consertMusician.consertId=concert.concertId inner join musician on consertMusician.musicianEmployeeId=musician.musicianEmployeeId GROUP BY consertMusician.musicianEmployeeId HAVING countConcert > 1;
1.SELECT fName,lName FROM conductor order by fname;._1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Concepts Question Answer 2022
|14
|1624
|54

SQL statements for data manipulation and database testing on Employees database
|19
|1637
|351

Entity Relationship Modelling Assignment
|17
|2659
|240

Proof of Testing SQL Queries Query 1 SELECT `memberName`,
|7
|327
|420

Proof of Testing SQL Queries Query 1 SELECT.
|8
|328
|68

Query and Update Databases Using SQL
|13
|275
|39