Student:Kavita
Q: You have been instructed to add a new student information to the students table. Because the student…
A: You have been instructed to add a new student information to the students table. Because the student…
Q: List names of all customers who live in a given zip code
A: Approach Start Create procedure Select a statement from the cursor End Display the procedure with…
Q: 5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum…
A: Max Function: It returns the maximum from the range of values. Syntax: MAX(number1, number2, ....)…
Q: Who has rented movies in Japanese language? Return only the first five distinct results in…
A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…
Q: Person(Name, Age, Phone, Extension) Find all names whose Extension starts with 5 folllowed by any…
A: we want it to start from 5, have exactly one character in the second place, which is denoted by the…
Q: Greens in Reg. is the percentage of time a player is able to hit the green in regulation; Putting…
A:
Q: QUESTION 2 Exercise: Create a statement that will show the sum of all the payments received on or…
A: The sql query for the following is
Q: 8- Write a query to generate the total number of invoices, the invoice total for all of the…
A: SQL is a language to operate databases in searching and filtering the data according to the query
Q: 3. Create a table for student mark list and insert the values for name, id, m1,m2,m3,m4,m5, total…
A: Since there is no programming language and approach mentioned we will be using C++ and object…
Q: Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test…
A: Formula bar For any active cell we use Formula Bar to write or edit any formula/data. Conditional…
Q: Question 9 What are the types of the y, z and w? int x = 3; auto y = x; auto&& z = x; auto&& w = 9;
A: What are the types of the y, z and w? int x = 3; auto y = x; auto&& z= x; auto&&…
Q: 1) Write the SQL code that will create the table structure for a table named EMP. This table is a…
A: For auto generated id's we have to start from 101 and increment by 1 For checking JOB_CODE we can…
Q: The HAVING clause applies to columns and expressions for individual rows, while the WHERE clause is…
A: Refer to step 2 for the answer.
Q: you are supposed to create an excel sheet for student grade sheet. There must be at least 10…
A: COUNTIF(range,criteria) : is used to count any occurrence of data. IF function return true or false…
Q: with it, paste your code in a text file named Student.txt and save it in your task folder. Write the…
A: This is a SQL question, here first we have to create a table student with a given parameter, then we…
Q: Return the artist’s full name, gender, date of birth (formatted like "06/12/2019"), and the name of…
A: CREATE TABLE artist (id INT NOT NULL,fname VARCHAR(30) NOT NULL,lname VARCHAR(30),dob DATE,hometown…
Q: Select name from instructor where name like '%Math' order by name; By default, the order by clause…
A: The question is: by default order by clause lists the item in which order? The answer is given in…
Q: Which of the following statements are true with respect to the DFS traversal of a graph. Statement…
A: Introduction :Given ,2 statements based on concept of graphs . We have to choose True / False out of…
Q: The Movie table has the following columns: ID - integer, primary key Title - variable-length string…
A: The select statement is as follows: SELECT Year, Count(*) from movie group by year;
Q: 7. Use the UNION operator to generate a result set consisting of three columns from the Products…
A: The UNION operator in SQL is used to combine the results of two or more SELECT queries into a single…
Q: Query 3: Write a parameter query to display the names of all prospects each member tried to recruit…
A: Here have to determine query for given problem.
Q: • List the staff names whose last name ends with a “d”. • List the staff names whose last name does…
A: Below is the complete solution with explanation in detail for the given questions about SQL…
Q: List the genre name and count of all tracks in each genre, in descending order of track count (so…
A: Hey there, I am writing the required solution of the above stated question.Please do find the…
Q: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is…
A: We have a dataset of orders containing order quantities and a corresponding price table. Our task is…
Q: Modify the SELECT statement to select the title and release date of PG-13 movies that are released…
A: Answer:
Q: ay last name of employees whose manager is KING. 8-Display last name, salary and job title of all…
A: Here are the SQL statements to perform each of the requested queries: SQL (Structured Query…
Q: Create lookup functions to complete the summary section.
A: Include the header files. Inside the main function take the array of elements. Pass to lookup…
Q: The Horse table has the following columns: ID - integer, primary key RegisteredName -…
A: Solution : The given query is : Select the registered name, height, and birth date for only horses…
Q: Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length…
A: Height should be between 15.0 and 16.0 (inclusive) . For this we will write Height >= '15.0' AND…
Q: a. Create table "STUDENT" with attributes "STUDENT_ID", "STUDENT_NAME", "STUDENT GPA". b. Use…
A: SQL query to create student table With appropriate datatype for each attribute Insert data of…
Q: Create table "STUDENT" with attributes "STUDENT_ID", "STUDENT_NAME", "STUDENT GPA". Use appropriate…
A: NOTE : There is a policy from bartleby to solve only first 3 subparts of a question.
Q: 9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all…
A: Write a SELECT statement that uses aggregate window functions to calculate the total due for all…
3. Create a table for student mark list and insert the values for name, id, m1,m2,m3,m4,m5, total and grade of each student. Calculate the grades using “if else / nested if” statement and display the total no. of student, total marks and grade of each student.
Output:
Total 5 Students
Student:Kavita, Marks:98
Student:Pritam, Marks:97
Student:Ayan, Marks:78
Student:Rishav, Marks:87
Student:Aziz, Marks:92
Do it in oracle sql
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- 3. Create a table for student mark list and insert the values for name, id, m1,m2,m3,m4,m5, total and grade of each student. Calculate the grades using "if else / nested if" statement and display the total no. of student, total marks and grade of each student. Output: Total 5 Students Student:Kavita, Marks:98 Student:Pritam, Marks:97 Student:Ayan, Marks:78 Student:Rishav, Marks:87 Student:Aziz, Marks:927. Use the UNION operator to generate a result set consisting of three columns from the Products table: Discount status A calculated column that contains a value of DISCOUNTED or FULL PRICE Product_name The product_name column discount_percent The discount_percent column If the product has a discount_percent greater than 0, the Discount_status column should contain a value of DISCOUNTED. Otherwise, it should contain a value of FULL PRICE. Sort the final result set by product_name.The HAVING clause applies to columns and expressions for individual rows, while the WHERE clause is applied to the output of a GROUP BY operation. True or False ?
- Create a table of your courses for this semester with fictitious grades for Test 1, Test 2, and Test 3 with appropriate weighting. The next column should determine the grade using the 'if' function, with plus and minus. The grade cell should show a discrete color scheme with below C- in red; above B in green and, yellow for the rest. This should be done using conditional formatting of cells.You have been instructed to add a new student information to the students table. Because the student is new, he has no marks before, you should not add an amount to the CGPA. The Students table contains these columns: Student_id NUMBER(10) Student_name VARCHAR2(30) Student phone NUMBER(10) CGPA NUMBER(2,2) Which INSERT statements will accomplish your objective? O a. INSERT INTO students VALUES (365, 'Khalil',99554721, 0 ) O b. INSERT INTO students VALUES (365, 'Khalil',99554721, 'NO CGPA' ) O c. INSERT INTO students VALUES (365, 'Khalil',99554721, NULL ) O d. INSERT INTO students VALUES (365, 'Khalil',99554721) Which line of code has an error? 1. CREATE TABLE FRUITS VEGETABLES 2. FRUIT TYPE VARCHAR2, 3. FRUIT NAME CHAR (20), 4. QUANTITY NUMBER (4)); O a. 1 O b. 2 O c. 3For each artist who is currently in a band and is under 30 years old: * Return the artist’s full name, gender, date of birth (formatted like "06/12/2019"), and the name of the band they are in with date joined formatted like "July 18, 2022". Order the results by artist name * You will not get full points if you just say something like DOB > '1992-07-18' (hard coded thirty tears ago today). The query would not age well! Tables and values are in the picture attached.
- QUESTION 2 Exercise: Create a statement that will show the sum of all the payments received on or after 2018-08-01. The new column should be titled recent payments_received Hint: If you did this correctly, you will have one column (and one row) showing the following amount 59755.88The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. -- Your SELECT statement goes hereSELECT *FROM HorseWHERE (Height >= '15.0' AND Height <= '16.0') OR BirthDate >= '2020-01-01';List names of all customers who live in a given zip code Feature 18: List names of all customers living in a given zip code. Input: Create a procedure with Cust_name, Cust_Zip and a cursor to store the select statement output into the cursor. Output: Displays a list of all the customer names for a specific zip code with the cursor. Example of calling the feature: Exec customer_name_by_ZIP(‘Daisy Brown’, 64277); using an exception too
- Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12*In R please How many non-NA and how many NA values are there in the table? Create a new variable ans of class table that gives total number of non-NA as well as NA entries. The first component should be number of non-NA's, the second should be number of NA's. (You should have just one line of a code). New York Air Quality Measurements Description Daily air quality measurements in New York, May to September 1973. Usage airquality Format A data frame with 153 observations on 6 variables. [,1]OzonenumericOzone (ppb)[,2]Solar.RnumericSolar R (lang)[,3]WindnumericWind (mph)[,4]TempnumericTemperature (degrees F)[,5]MonthnumericMonth (1--12)[,6]DaynumericDay of month (1--31) Details Daily readings of the following air quality values for May 1, 1973 (a Tuesday) to September 30, 1973. Ozone: Mean ozone in parts per billion from 1300 to 1500 hours at Roosevelt Island Solar.R: Solar radiation in Langleys in the frequency band 4000–7700 Angstroms from 0800 to 1200 hours at Central Park Wind:…¥ Question Completion Status: Given a truth table below with the first two columns of truth values provided: b. (p.q) 1 2 T F 4. Which of the answers below contains the truth values for the third column when f(p,q) = p q ? Column 3 Column 3 Column 3 truth values: Column 3 truth Column 3 truth values: truth values: truth values: values: 1 T 1 F 1 F 1 F 1 T None of the other answers O 2 F O 2 T 2 T 2 T provided is correct. 2 F 3 F 3 F 3 T 3 T 3 F 4 T 4 F 4 T 4 F 4 T Save All Answers Save and Su Click Save and Submit to save and subrmit. Click Save All Answers to save all answers. 0 日 la (99+ here to search 3.
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)