a. Insert the sample data into the tables(at least 4 rows in each tables). 3. Write Queries for the following: a. List all student whose Surname begins with b or end with a or begins and end with e. b. Select all those students who don't take any year enrolled. c. List student name and Surname, studentID and year enrolled for those students who enrolled in the range 2004 to 2021. d. Find the number of course for each student. e. List full details of students that don't have any course. f. Change the Date of birth of any student to 18-09-1992. g. Delete the information of the student younger than 20 years old

a. Insert the sample data into the tables(at least 4 rows in each tables). 3. Write Queries for the following: a. List all student whose Surname begins with b or end with a or begins and end with e. b. Select all those students who don't take any year enrolled. c. List student name and Surname, studentID and year enrolled for those students who enrolled in the range 2004 to 2021. d. Find the number of course for each student. e. List full details of students that don't have any course. f. Change the Date of birth of any student to 18-09-1992. g. Delete the information of the student younger than 20 years old

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4RA

See similar textbooks

Similar questions

I need help with this: Exercise 32.6 (Find tables and show their contents) Write a program that fills in table names in a combo box, as shown in Figure 32.30b. Figure 32.30b You can select a table from the combo box to display its contents in the text area. Use the Access database exampleMDB.accdb for this exercise. Place the database file in: C:\data\
ASSUME 6.2 IS DONE Write a SQL statement to get the list of all the tasks that started after2022-05-10. Include all the columns from the task table. Write a SQL statement that returns a list of the team members with alltheir tasks. Include the team member’s name and the description ofthe task in the results. Write a SQL statement to get a list of the tasks in the database,arranged by duration from largest to smallest. Include all the columnsfrom the Task table.
A better design would be one with the following tables: Patient : | pid | name | dob | addr | tel | Exam : | acc | pid | eid | result | date | ExamDictionary : | eid | name | normal | Questions: Create SQL queries (select statements) that accomplish the following. 1. List all of the Exams for Ms. Jones (pid=12). 2. List all of the Patients that hail from jolly old London. 3. List all of the Exams with results that exceed their normal. 4. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal. 5. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal, but list names only once and in alphabetical order.
Database cource: a. Display student name and department name using the above view. b. Write a plsql program using cursors to display contents of table Dept.
create a table job_history including columns employee_id,start_date,end_date,jobname and department name and make sure that the employee_id column doesnot contain any duplicate value.write a Java program to insert atleast four records.by using prepared statement display job name and department name corresponding to a particular year.
Insert, Update, and Delete statements can be referred to as blank queries. a result b select c database d action
POSTGRESQL For this problem create a table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor and adds a tuple to the instructor_course_nums table consisting of the instructor's ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the instructor_course_nums table is up-to-date. You must name your procedure: <LastName>_<DOB_DayOfMonth>_insCourseNumsProcWhere <LastName> is your last name and <DOB_DayOfMonth> is the day of the month you were born. Below is an example of how I named my procedure: Morab_05__insCourseNumsProc
Question 2: implement get_athletes() function and return a list of athletes* Requirement: the information for an athlete should include name, country,* picture path and the game name (column name: gamename) that the athlete will attend.* Hint: Use selecte statement for inner join* Reference: Week 2*/function get_athletes() { //implement your codes here // return $athletes;} ?>
Write ALTER TABLE statements for each table to create Primary Keys and Foreign Keys where applicable. (Preferable save to notepad) use exercise2: CREATE TABLE CUSTOMER ( CUS_CODE int, CUS_LNAME varchar(15), CUS_FNAME varchar(15), CUS_INITIAL varchar(1), CUS_AREACODE varchar(3), CUS_PHONE varchar(8), CUS_BALANCE float(8) ); INSERT INTO CUSTOMER VALUES('10010','Ramas','Alfred','A','615','844-2573','0'); INSERT INTO CUSTOMER VALUES('10011','Dunne','Leona','K','713','894-1238','0'); INSERT INTO CUSTOMER VALUES('10012','Smith','Kathy','W','615','894-2285','345.86'); INSERT INTO CUSTOMER VALUES('10013','Olowski','Paul','F','615','894-2180','536.75'); INSERT INTO CUSTOMER VALUES('10014','Orlando','Myron','','615','222-1672','0'); INSERT INTO CUSTOMER VALUES('10015','O''Brian','Amy','B','713','442-3381','0'); INSERT INTO CUSTOMER VALUES('10016','Brown','James','G','615','297-1228','221.19'); INSERT INTO CUSTOMER…
Please write these statements for (i), (ii) and (iii) using the data and tables I've presented. Similar to how you answered (iv), (v) and (vi)
Question 13 Given the following declaration of records and the name of the records, write the full program to create two records and assign values based on the following details.table parttime stname(ahmed hassan) , stadress(Dubai)stphone(052772711)CGPA(3.56) Question13 table 2 table name fulltime stname(nuha Ali)stadress(abudhabi)stphone(0542227222)CGPA(3.88)
Computer Science -- 1.Write a SELECT statement that returns InvoiceId and Total from the Invoice table. Use the CONCAT function to insert a ‘$’ in the front of the total value -- 2.Write a SELECT statement that returns CustomerId and average Total from the Invoice table grouped by customerId. Use the CONCAT function to insert a ‘$’ in the front of the average total and the FORMAT function to to display it with commas and 2 decimal places.