Recitation - SQL Queries - Edubirdie

University:
Massachusetts Institute of Technology
Course:
15.992 | S-Lab: Laboratory for Sustainable Business
Academic year:

2023
Views:

291

Pages:

1
Author:

Zachery Copeland

Information Technology I SQL Query Exercises • Find First Name and Last Name for all employees who work for the ‘Research’ department SELECT FNAME, LNAME FROM EMPLOYEES, DEPARTMENT WHERE DNAME = “Research” AND DNUMBER=DNO; • For each employee, retrieve the employee’s First and Last name and the first and last name of his/her immediate supervisor SELECT E.FNAME, E.LNAME, S.FNAME, S.LNAME FROM EMPLOYEES AS E, EMPLOYEES AS S WHERE E.SUPERSSN = S.SSN; • How many employees work in the ‘Research’ department? SELECT COUNT(*) FROM EMPLOYEE, DEPARTMENT WHERE DNO=DNUMBER AND DNAME=”Research”; • What is the maximum, minimum, and average salary in the ‘Research’ department? SELECT MIN(SALARY), MAX(SALARY), AVG(SALARY) FROM EMPLOYEE, DEPARTMENT WHERE DNO=DNUMBER AND DNAME=”Research”; • For each project on which more than two employees work, retrieve the project number, project name, and number of employees who work on that project SELECT PNUMBER, PNAME, COUNT(*) FROM PROJECT, WORKS_ON WHERE PNUMBER=PNO GROUP BY PNUMBER HAVING COUNT(*)>2; • For each project, retrieve the project number, project name, and number of employees from department 5 who work on this project SELECT PNUMBER, PNAME, COUNT(*) FROM PROJECT, WORKS_ON, EMPLOYEE WHERE PNUMBER=PNO AND SSN=ESSN AND DNO=5 GROUP BY PNUMBER;

Related Documents

Recitation - SQL Queries

Recitation - SQL Queries - Page 1

of 1

Recommended Documents

Should Motorola Embrace 100% the Linux Operating System (OS) For Smartphones

Should Motorola Embrace 100% the Linux Operating System (OS) For Smartphones

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Integrated Development Environments

Integrated Development Environments

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Matching Supply and Demand - Tug of War

Matching Supply and Demand - Tug of War

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Supply Chain Management - Value of Information

Supply Chain Management - Value of Information

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Roadmap for Service Excellence

Roadmap for Service Excellence

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Bargaining Simulation All Secret Instructions

Bargaining Simulation All Secret Instructions

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Coalition Exercise - Questions for Reflection

Coalition Exercise - Questions for Reflection

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Assignment Description for the PIE Letter

Assignment Description for the PIE Letter

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Answer Key

Information Technology Introduction to User Interface Building with Access Examples

Information Technology Introduction to User Interface Building with Access Examples

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Information Technology Local Area Networks; Ethernet; Packet-switched Networks

Information Technology Local Area Networks; Ethernet; Packet-switched Networks

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Assignment Due - PS4 due, Networks and Computer Security

Assignment Due - PS4 due, Networks and Computer Security

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Answer Key

Prepare Worksheet for Angry Negotiation Game

Prepare Worksheet for Angry Negotiation Game

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Answer Key

New Documents from this Course

Managing Teams

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Global Management

Global Management

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Managing Information

Managing Information

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Planning

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

A Guide for Preparing Your Workplan

A Guide for Preparing Your Workplan

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Action at the Industry and Societal Levels - Industry Collaborations

Action at the Industry and Societal Levels - Industry Collaborations

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Green Buildings - New Markets and Services

Green Buildings - New Markets and Services

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Case Example of Alternative Transportation Opportunities

Case Example of Alternative Transportation Opportunities

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Sustainable retail. Can big box stores really go green

Sustainable retail. Can big box stores really go green

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Organizational response

Organizational response

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Lecture Note

Bargaining Simulation General Instructions

Bargaining Simulation General Instructions

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Answer Key

Tax Considerations in Deal Structures

Tax Considerations in Deal Structures

Massachusetts Institute of Technology 15.992 | S-Lab: Laboratory for Sustainable Business

Answer Key