SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions for products provided by a vendor in area code 615. Remember, the main difference between a correlated subquery and uncorrelated subquery is that, in a correlated subquery, the inner query is dependent upon the outer query, while, with an uncorrelated query, the inner query does not depend upon the outer query. Instead, it runs just once. You should NOT use union, minus, or intersect in this query. The outer query will use the PRODUCT table and the inner query will use the VENDOR table [hint: you should have 9 records of output].   My code: select p_descript from product where (select v_areacode from vendor where v_areacode = '615' ; I am getting this error, problem is I can't see what is missing any assistance is appreciated.  ORA-00936: missing expression

Let's wa(k through a review of basic SQL syntax, using as an example the database that was mentionedearlier. This database has the following simple structure(* indicates a primary key):Courses: CourseID*, CourseName, TeacherIDTeachers: TeacherID*, TeacherNameStudents; StudentID*, StudentNameStudentCourses: CourseID*, StudentID*Using the above table, implement the following queries.Query 1: Student Enrollment Query 2: Teacher Class Size

Database Systems please help me answer this question I will give you a good rating Thank you!

Your implementation must directly follow a comment with a specification of a subtask.(1) First, write a SQL statement to create a new relational table SALARY that consists oftwo columns salary_level and minimum_salary. The columnsalary_level is defined the same type as it defined in a table LPOSITION. Thecolumn minimum_salary type is decimal that can store the value between 0.00and 999999.99. The primary of the SALARY is salary_level.(2) Next, write SQL statements to inserts into the relation table SALARY informationabout salary levels and minimum salaries by using the data in a table below.+--------------+---------------------+| Salary level | Minimum salary |+--------------+---------------------+| A | 56700.00 |+--------------+---------------------+| B | 65500.00 |+--------------+---------------------+| C | 77800.00 |+--------------+---------------------+| D | 89600.00 |+--------------+---------------------+| E | 105300.00 |+--------------+---------------------+   (3) Next, write a…

A key for this database is {Departure Time}. Enter a different key for the database. Airline Flight Number Gate Destination Departure Time FlyRight 221 34 Denver 08:27 JetGreen 222 13 Anchorage 08:43 JetGreen 199 22 Honolulu 08:46 JetGreen 322 34 Anchorage 09:36 FlyRight 122 33 Honolulu 09:45 FlyRight 323 22 Detroit 09:50 FlyRight 222 33 Denver 09:55 Key: { Ex: Gate

Composite main keys have prospective keys.

A cake shop named "Whisk" has an online presence. It has multiple flavors of cakes supplied by various vendors. The manager wants to know the cost of the available quantity. Write a sql query to get the total cost of the available cakes. Code should run on Mysql. Data type along with the sample input and output is mentioned below:- Cake: Column Type Cake_Id int Flavor varchar(100) Cost  int Producer varchar(20) Stock int Sample Input :- Cake: Cake_id Flavor Cost Producer Stock 1001 Vanilla 450 Just bake 8 1003 Chocolate 500 Flower Aura 12 1004 Red velvet 600 Bakingo 1 1005 Strawberry 700 Bigbasket 2 1006 Cinnamon 900 Creamy 1 1007 Vanilla  900 Creamy 2 1008 Mango 900 Just bake 2 1009 Strawberry 550 Creamy 2 Sample output - 17200

In SQL  This sample database consists of the following tables(see image for tables and there is one more at the bottom in this text):• Customers: stores customer’s data• Products: stores a list of scale model cars• ProductLines: stores a list of product line categories• Orders: stores sales orders placed by customers• OrderDetails: stores sales order line items for each sales order• Payments: stores payments made by customers based on their accounts• Employees: stores all employee information as well as the organization structuresuch as who reports to whom• Offices: stores sales office data Write SQL code for the following:We want to add a new sale order for the customer (customerNumber = 145) in thedatabase. The steps of adding a sale order are described as follows:(1) Get latest sale order number from “orders” table, and use the next sale ordernumber as the new sale order number(2) Insert a new sale order into “orders” table for the customer (customerNumber =145). For this order, the…