_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID, DEPARTMENT_NAME) Department (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID) Location (LOCATION_ID,STREET_ADDRESS,POSTAL_CODE,CITY,STATE_PROVINCE,COUNT RY_ID) Write a query in SQL to display the DEPARTMENT_NAME of all those Departments whose DEPARTMENT_ID is greater than the DEPARTMENT_ID of Physics department. Write a Query in SQL to show the FIRST_NAME of all those employees whose salary is less than the salary of all those employees whose MANAGER_ID is 101 or 102.

SQL Question~ Write SQL expression to list flight_no and airline_code of all the bookings for customers with first name Sam and city Chicago

Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).

Need help writing SQL queries for sample data base

SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years.  3. Find the names of buildings where more than 50 employees work.  4. The tables have…

Intersection table is needed when you have a relationship     1:1     M:N     M:1     1:M

sql code sql code sql code

Based on SQL query knowledge

I need help with this question for my Database Management class for SQL developer. Thank you   REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE)   Question: List TOY category items and orders placed for them.  Report:  Item_Num, Description, Order_Num, and Order_Date

SQL Query Relational Algebra select avg(customer.age) as "avg_age" from AVG(avg_age) (customer) customer; 1. Select customer phone, customer.address, customer.fullname from customer where exists (select * from billing where billing.cid = customer. Customer id); 2. Select * from customer where customer.address in ('Ibri'); 3. Select billing.bill id from billing Group by bill id Having count (case when billing.b status = 'REJWCTED' then 1 end) >1; select * from customer order by full name, age;