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

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.
Write a SQL query to retrieve the First_name of employees having any of the following SSN_NUMBER 123456789, 987654321. Attribute Data Type Constraint First Name Varchar(15) Not Null Last Name Varchar(15) Not Null SSN Number Char(9) Primary Key
Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com | 2010-06-18 Irfan@abc.com Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.
I need help with the SQL query for the following question: 1. Show the total number of customers who complained about Bluetooth issues for every product name of every manufacturer from every retailer 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 SQL statements to the following queries. Retrieve PRODUCT_NAME for the second maximum product UNIT_PRICE (use subquery).
Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.
What is the significance of the Log Output line?
Write an SQL query to determine the total number of hours and the total number of lessons Tutor 106 taught in June and July 2015.