use the picture below (the data has been shown) to create a sql statement that will enter the following record into part table part number:BZ68 description: switch unit price:29.99

You have the following table: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) Write a Stored Procedure that returns the last name and first name for all managers in a department with the DEPARTMENT passed in as a parameter. Answer: To write a stored procedure

Trying to write SQL statements for these shown here and having issues with them working. Explanation on this would be appreciated.

Write the SQL statements to perform the following operations: a. Create a new course "CS-001", titled "Weekly Seminar", with 0 credits. b. Create a section of this course in Fall 2017, with sec id of 1, and with theclocation of this section not yet specified. c. Enroll every student in the Comp. Sci. department in the above section. d. Delete enrollments in the above section where the student’s ID is 12345. e. Delete the course CS-001. What will happen if you run this delete statement without first deleting offerings (sections) of this course? f. Delete all takes tuples (i.e., rows) corresponding to any section of any course with the word "advanced" as a part of the title; ignore case when matching the word with the title.

Task 5: The InstantRide Management team considers creating a new team for Car Maintenance. The new team needs to find/list the cars that are used more than average with the usage count. Collect the information of all rides and consolidate over the Car IDs. You need to create a three level SQL statement. Firstly, you need to COUNT the number of rows in TRAVELS and GROUP_BY the CAR ID field. Then you need to calculate the AVG of the data to find the average usage of the cars. Finally, you need to return CAR_ID and the TRAVELS count (as the Usages column) filtered to only values greater than the calculated average. Task Query all cars used more than the average.

Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image )the question is:2. Get employee details from employee table whose first name starts with 'J', order the result descending.

Using the Online SQL Editor, answer the following questions with screenshots. Link: https://www.programiz.com/sql/online-compiler/ 1. Show all columns from Order table then add a new column titled "Lowest Price", where such column flags or labels all amounts less than or equal to 300 as "Items 300 and below". Answer(screenshot of code & output from SQL Editor) 2. Show last name, first name, and age columns from Customers table then add a new column titled "Age Label",where such column flags or labels all ages 25 and above as "Tigulang na" and ages below 25 as "Bata pa ah". Answer(screenshot of code & output from SQL Editor) 3. Provide the order id, item and sum (amount) of all items with a total (sum) amount greater than 400; rename the sum (amount) column as "Total Amount"; then group the result by order_id. Answer(screenshot of code & output from SQL Editor) 4. Show the customer id, last name, and first name of all customers who ordered items with an amount greater than...

Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO 101 John Abraham 10000 01-JAN-13 11 202 Michael Clarke 80000 01-JAN-13 22 303 Roy Thomas 70000 01-FEB-13 11 404 Tom Jose 60000 01-FEB-13 22 505 Jerry Pinto 65000 01-FEB-13 22 606 Philip Mathew 75000...

You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.

Based on SQL information

True or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means "all the tuples". In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.

8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands

SQL procedure a. Write a procedure in SQL that inserts a new customer record into the "Customers" table. b. Create a procedure that updates the quantity of a product in the "Inventory" table based on the product ID. c. Write a procedure that calculates the average salary of all employees in the "Employees" table and displays the result.