1. 3. Find id of students who have obtained mark lesser than or equal to minimum markobtained in Mathematics in section 2.STUDENT_MARKSA (Ctrl)StudentIdStudentName GenderSQLWebApp Mathematics Course Section46J12035AzhilaF785989146S11114SulthanM887887146J21113RashidM676971146J22145MahmoodM777679246S11111MoosaM69717246S21456MohammedM86789146J14569ReshmaF76867746J24689FatmaF88868146J13564AmaniF798988146J12456NoorF787976

Note : Here I have done the coding in SQL language Description : I have used nested sql statement.…

1. 3. Find id of students who have obtained mark lesser than or equal to minimum mark obtained in Mathematics in section 2. (Ctrl) - StudentId StudentName Gender SQL WebApp Mathematics Course Section STUDENT_MARKS 46J12035 Azhila 78 59 89 46S11114 Sulthan M 88 78 87 1 46J21113 Rashid 67 69 71 1 46J22145 Mahmood M 77 76 79 46S11111 Moosa M 69 71 72 46S21456 Mohammed M 86 78 91 46J14569 Reshma F 76 86 77 46J24689 Eatma F 88 86 81 46J13564 Amani F 79 89 88 46J12456 Noor F 78 79 76

1. 3. Find id of students who have obtained mark lesser than or equal to minimum mark obtained in Mathematics in section 2. (Ctrl) - StudentId StudentName Gender SQL WebApp Mathematics Course Section STUDENT_MARKS 46J12035 Azhila 78 59 89 46S11114 Sulthan M 88 78 87 1 46J21113 Rashid 67 69 71 1 46J22145 Mahmood M 77 76 79 46S11111 Moosa M 69 71 72 46S21456 Mohammed M 86 78 91 46J14569 Reshma F 76 86 77 46J24689 Eatma F 88 86 81 46J13564 Amani F 79 89 88 46J12456 Noor F 78 79 76

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

List all products with their highest unit price, i.e. not discounted.the database is
i need the answer quickly
write SQL statement to search for employees whose manager is specified by the txtEname box
database: sql Q1. Create the following tables: Carrier Attribute name Type Size Constraint carrierID Varchar2 10 Primary key carrierName Varchar2 100 NOT NULL Phone Varchar2 50 LIKE ‘+966%’ Range Varchar2 30 Value is either ‘International’ or ‘Local’ Review Attribute name Type Size Constraint ReviewID INT Primary key Stars INT NOT NULL Comment Varchar2 70 Name Varchar2 50 Default ’User’ CustomerID INT Foreign key references customers ProductID INT
Create an anonymous block in PL/SQL to list all the countries from Country table where Currency contain keyword ‘Dollar’. Perform following steps: Create user define type with name of the country, currency.Type should contain datatype for name and currency using %type only.Display should include Name of the country, currency code using user defined type. Filter for the data : All the countries from Country table where Currency contain keyword ‘Dollar’.
Consider the following table: Instructors ID 12121 15151 22222 32343 33456 name Alice Wu John Mozart Frank Einstein El Said Chelsea Dunn deptName Finances Music Physics History Physics salary 90000.00 40000.00 95000.00 60000.00 90000.00 Write a single SQL query to list in descending order the deptNames and names of all instructors. Note that every column of Instructors should be included in the result.
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
sql code sql code sql code
The query in the figure below. PROGRAM 1 Dept ID PROGRAM ACADEMIC ADVISOR STUDENT OFFICE PHONE 1 SID Name GPA Gender Dept ID Field: SID Table: STUDENT Sort Show Criteria: Name STUDENT PROGRAM PROGRAM GPA STUDENT Accounting" or Name and PROGRAM for the students who registered in the A program "Accounting" will be listed SID, Name, PROGRAM, and GPA for the students who registered in the B program "Accounting" will be listed SID and GPA for the students who registered in the program "Accounting" will be listed Name and GPA for the students who registered in the program "Accounting will be listed
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.
SQL homework Please help me with this homework
Find the Primary Keys and P3,6 for the database: Make Model Engine ID Ford Mustang Ford Fiesta Chevy Camaro Chevy Caprice Olds Cutlass Olds Cutlass Volvo P1800 Volvo 240 Volvo 760 Year 1972 A1222 1989 C54322 1991 754342AH 1989 442355CC 1992 ANDU33 1992 ANGH28 1969 44325XX 1986 53526PD 1992 578868R Vehicle ID FO13579 FO24245 CH172389 CH156738 OL64332 OL61998 V044526 VO64690 V083529 Color Black Yellow Black Yellow Blue White White Black Blue