Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT SELECT Name, Dept, Salary FROM employees WHERE name LIKE'_a%' AND salary IS NULL; Which of the following will be the output after executing the statémer Name Dept Salary Tafal IT Ob. Name Dept Salary Aminah IT 600 Zainab Admin 400 Name Dept Salary Zainab Admin 400 O d. Name Dept Salary Aminah IT 600

Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT SELECT Name, Dept, Salary FROM employees WHERE name LIKE'_a%' AND salary IS NULL; Which of the following will be the output after executing the statémer Name Dept Salary Tafal IT Ob. Name Dept Salary Aminah IT 600 Zainab Admin 400 Name Dept Salary Zainab Admin 400 O d. Name Dept Salary Aminah IT 600

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME BLOOD TYPE PCR TEST DOB GENDER PHONE FAX WEIGHT SMOKER 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT NVL2 (phone, fax, 0) FROM patients WHERE medical no = 1005; Answer:
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME DOB GENDER BLOOD TYPE PCR TEST PHONE FAX WEIGHT SMOKER 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinal 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 Shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT COALESCE (phone, fax, 9999) FROM patients WHERE blood_type='A'; Answer:
SQL Query question
Write SQL queries for the following. Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator. Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator. Display details of those doctors who neither belong to Isb nor Rwp nor Multan without using in and like operator. Display full name of doctors whose first name is other than Tania. Display first name of doctors whose first name contains any of vowels (a,e,i,o,u). Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’ Display details of those male patients whose age is 25 or 36. Display details of those patients whose name contains less than 5 characters. Display first 4 doctors who are earning least salary. Display details of all patients in such a way that female patients are shown before male patients. Display the unique cities from doctor table. Display all…
Oracle sql Task 2: Write a function that returns how old a book is Published before 2000 ->Book X by author Y is an old book Between 2000 and 2020 -> Book X by author Y is modern 2020 and later -> Book X by author Y is recently published X: book name Y: author name
Trying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.
QUESTION 2. Write a PL/SQL PROCEDURE that can list the Top-N customers (id and name) and the amounts spent in a specified year together with their rank. The customer rank can be obtained from the function created in the previous question. The total purchase is calculated for each customer using the quantity and price columns. The total purchased is sorted from the highest to the lowest. The procedure will have two input parameters: year (NUMBER) and TOP_N (NUMBER). Hint: • use ONE EXPLICIT CURSOR (corresponding to one select statement). • Us the topN technique (from clause subquery) and rownum to limit the customers. Expected Output for Top 3 customers in 2018 using: execute topSpenders (2018. 3) 3 Gary Jenkins s422.64 Excellent 45 Fred Fontain $359.21 Excellent 16 Ralph Foster $351.64 Excellent Expected Output for Top 10 customers in 2018 using: begin topSpenders(2018,10 end: 3 Gary Jenkins s422.64 Excellent 45 Fred Fontain $359.21 Excellent 16 Ralph Foster $351.64 Excellent 81…
Write an SQL query display the employee name who's job description is Technical with his/her plan description
Write a query in SQL to display all the data of customers, in Table customers, that live in New York or California SELECT city FROM customers WHERE city = 'New York' OR city = 'California' SELECT * FROM customers WHERE city = 'New York' AND city = 'California' SELECT * FROM customers WHERE city = 'New York' OR city = 'California' SELECT ALL FROM customers WHERE city = 'New York' OR city = 'California' %3D
Based on the following tables, write appropriate SQL statements to carry out the following tasks: CLIENT CLIENT_NAME LOCATION SAM LEE MELAKA LEE MEI TENG PENANG ΚΙΚΟ ΤΑΝ KL ADAM ALI KL EVA KUMAR MELAKA SALESPERSON SALES_NAME POSITION AREA JAMES ANG JUNIOR MELAKA MARCUS TEO SENIOR PENANG LILY TAY JUNIOR KL (a) Add the following record into the SALESPERSON table. SALES_NAME POSITION AREA JOYCE SENIOR MELAKA (b) Show how all junior salesperson can be removed from SALESPERSON. (c) Change Lily's position as she has been promoted from junior to senior level. (d) Retrieve all clients who are located in Melaka. Sort the result in ascending order by location. (e) Display the number of clients in each location. (f) Display those clients with the surname “Lee". (g) List the salesperson name and position for all senior salesperson from Penang. (h) List the salesperson and client names who are located in the same area.
Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
Write a SQL query that displays the number of customers who born on the 16th day of a month . Write in SQL a query that displays the ids of the customers who have the highest income . Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials . my SQL and orcale language