STUDENTFirst Name Last Name Gender Address Postal Code Mobile Phone019-6953666012-6358997IC no986235453A00356489Hui HongAbdullahYapFCheras81000FSofiaA02135655 Abdul Shukor Abdul LatifMelatiYongHairiKlang33000Ampang6500063100M016-3677451A03659874A16597755A18634562A19684572ManafPandan012-1326459Ah FokMCheras63400016-565897053110AmpangKajangMelawati013-5671259019-3332222012-6598455YaakobMNathanMuthuM99000A23568897 YusnizaHassanF32400INSERT INTOVALUES ('A03659874', 'Melati', 'Manaf, 'F', 'Pandan', '63100', '012-1326459');INSERT INTOVALUES ('A16597755', "Yong', 'Ah Fok', 'M', 'Cheras', '63400', '016-5658970');INSERT INTOVALUES ('A18634562', 'Hairi", "Yaakob', M', 'Ampang', '53110', '013-5671259');INSERT INTOVALUES ('A19684572', 'Nathan', 'Muthu', 'M", 'Kajang', '99000', '019-3332222');:INSERT INTOVALUES ('A23568897', 'Yusniza', Hassan', 'F', 'Melawati', '32400', '012-6598455'); Answer this following question using SQL Statement.From table STUDENT :Write a SQL Query to show:1. First Name, Last Name and Address for Student that live in Ampang.2. First Name, Last Name and Address for student's address will start with K.3. First Name, Last Name, Gender and Mobile Phone for female student.4. First Name, Last Name and Numbor IC for student IC_no start with A1.5. First Name, Last Name and Gender for male student and name will start with letter"Y".

1. select first_name, last_name, address from student where address='Ampang'; 2.…

Answer this following question using SQL Statement. From table STUDENT : Write a SQL Query to show: 1. First Name, Last Name and Address for Student that live in Ampang. 2. First Name, Last Name and Address for student's address will start with K. 3. First Name, Last Name, Gender and Mobile Phone for female student. 4. First Name, Last Name and Numbor IC for student IC_no start with A1. 5. First Name, Last Name and Gender for male student and name will start with letter

Answer this following question using SQL Statement. From table STUDENT : Write a SQL Query to show: 1. First Name, Last Name and Address for Student that live in Ampang. 2. First Name, Last Name and Address for student's address will start with K. 3. First Name, Last Name, Gender and Mobile Phone for female student. 4. First Name, Last Name and Numbor IC for student IC_no start with A1. 5. First Name, Last Name and Gender for male student and name will start with letter

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

Using the university schema, write an SQL query to find the name and ID of each History student whose name begins with the letter ‘D’ and who has not taken at least five Music courses.
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL_NO FIRST_NAME SUR_NAME DOB GENDER PHONE FAX BLOOD_TYPE WEIGHT SMOKER PCR_TEST 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A. 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male B 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 B 35 NO Negative SELECT CONCAT (SUBSTR(first_name, 1,2), weight) FROM patients WHERE blood_type= 'B' and weight > 70; Answer:
How do you qualify the name of a field in an SQL query? When is it necessary to do so? give few examples
Write SQL query to fetch the Names of all employees in IT department from table Employee (Name, Id, Department, Mobile)
Using the university schema, fill in the blank to complete the SQL query that finds the ID and name of each student who has not taken any course offered before 2017.
I need help with the SQL query for the following question: 1. Get a list of 5 reviews for shoppers in Chicago Here is the information on the field names: The table name is: Reviews Review Form Fields Product/ModelName: Product/Category: Product/Price: Retailer/Name: Retailer/ZipCode: Retailer/City: Retailer/State: Product/On Sale: Manufacturer/Name: Manufacturer/Rebate: Review/UserId: Review/Rating: Review/Date: Review/Text: Example of Review Form Filled out ProductModelName: Galaxy S4 ProductCategory: Smart Phone ProductPrice: 499 RetailerName: Bestbuy RetailerZipCode: 44114 RetailerCity: Cleveland RetailerState: OH ProductOnSale: No ManufacturerName: Samsung ManufacturerRebate: No ReviewUserId: xmm473 ReviewRating: 3 ReviewDate: 6/10/2012 ReviewText: overheats after 2 hours
Write a SQL query to find the highest salary from the table Salaries(E_ID, E_Name, E_Post, Salary).
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.
Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO 101 John Abraham 10000 01-JAN-13 11 202 Michael Clarke 80000 01-JAN-13 22 303 Roy Thomas 70000 01-FEB-13 11 404 Tom Jose 60000 01-FEB-13 22 505 Jerry Pinto 65000 01-FEB-13 22 606 Philip Mathew 75000…
Write PL/SQL coomands for the following question5. Table student( name,age,inter_mark,entrance_rank,address,contact_no,ID,branch)Admission( college_name,mode( pay/free/star/NRI), date,ID)a) Write a query to display the students who are all admitted on starmode branchwiseb) Display the college under which maximum NRI student admittedc) Display the college which got minimum free students and atmost one NRI studentd) Display the student who got second maximum rank admission detailse) Display the students category wise admission detailsf) Write a plsql routine to check a perfect square number is the given number.
Write an SQL query to find numbers of months between the dates 12/12/2020 and 12/12/2021. Also find last day in month 12.
Write an appropriate SQL query to determine which modules have the same number of credits.