display SQL query with screenshots Id12345678910Instruction:LastNameSantosNonatValenciaCamposMoralesAtienzaDela CruzRamosGalangDeteraFirst NameMark AnthonyJaysonNicoleJaneMicahEldibertPhilipLoisaOrleanChin1. Display all Junior2. Display all Male3.Display all Female4. Display all 18 and above years oldAge17152019211716211816GenderMaleMaleFemaleFemaleFemaleMaleMaleFemaleMaleFemaleLevelFreshmanSophomoreSeniorJuniorSeniorSophomoreFreshmanSeniorJuniorFreshman

Id 1 2 3 4 5 6 7 8 9 10 Instruction: LastName Santos Nonat Valencia Campos Morales Atienza Dela Cruz Ramos Galang Detera 1. Display all Junior 2. Display all Male 3. Display all Female 4. FirstName Mark Anthony Jayson Nicole Jane Micah Eldibert Philip Loisa Orlean Chin Display all 18 and above years old Age 17 15 20 19 21 17 16 21 18 16 Gender Male Male Female Female Female Male Male Female Male Female Level Freshman Sophomore Senior Junior Senior Sophomore Freshman Senior Junior Freshman

Id 1 2 3 4 5 6 7 8 9 10 Instruction: LastName Santos Nonat Valencia Campos Morales Atienza Dela Cruz Ramos Galang Detera 1. Display all Junior 2. Display all Male 3. Display all Female 4. FirstName Mark Anthony Jayson Nicole Jane Micah Eldibert Philip Loisa Orlean Chin Display all 18 and above years old Age 17 15 20 19 21 17 16 21 18 16 Gender Male Male Female Female Female Male Male Female Male Female Level Freshman Sophomore Senior Junior Senior Sophomore Freshman Senior Junior Freshman

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

sorry needed sql
Using php and sql: create a query that will output only the user_id and message for user_id 8
SQL problems
question Design a SOQL query with inline soql to display the Account history data. Design the history Query for account. Salesforce Development, Query, SOQL
TASK: Examples of the UNION operator, the use the DISTINCT operator. TOPIC : DATABASE
Explain the SQL function categories in database
Computer Science write a sql script to change only the first character in a given full name into capital letter(only the begining of the names is capitalized ) add explanation in the steps
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
CREATE TABLE is an example of a Data Manipulation Language (DML) statement. 1) True 2) False