Consider the following SQL query:SELECT customer_id, customer_nameFROM customers cWHERE EXISTS ( SELECT order_id FROM orders o WHERE o.customer_id = c.customer_id AND o.total > 1000);Which of the following best describes this query?

You want to find the first product sold by each store based on the sale date. Which window function would be most appropriate?

A(n) ____ join returns not only the rows that have matches in both tables but also unmatched rows from either the left or right table.

`join_date` indicates the joining time of a user and is a datetime field with values such as ‘2024-03-02 11:15:00’. Which of the following conditions finds all users who joined on September 30, 2024?

A data scientist is tasked to query a MySQL table named “invoices” and return the “invoice_id”, “invoice date”, and “order” columns. Which of the following SELECT statements is most suitable?

_____ is a set of SQL commands used to add, delete, modify, and query data in a database.

Which statement correctly describes the behavior of IFNULL(phone, ‘–‘)?

OBJECTIVE OF THIS QUESTION: TO TEST STUDENTS’ KNOWLEDGE ON the LOOP.    FOR THIS QUESTION, YOU ARE NOT TO USE POW() FUNCTION! YOU NEED TO USE A LOOP!  USE OF POW() FUNCTION  == ZERO FOR THIS QUESTION  You can compute Pth power of a base number B by multiplying the base number ‘B’ p-times. Ex) 34 = 3x3x3x3 Create a script that will 1. Prompt the user to type in the base number B and the Power P. 2. Compute BP. 3. Display the Result.    Please, use the following Demoshot as an Example!     

Suggested Time < 1 hr. UPLOAD C Script! Objective: To check students knowledge on ARRAYs and LOOPs. We have a shape with “n” sides. You would like to know the distance between adjacent vertices. Also, you want to know the average distance, median distance, the shortest distance, and the longest distance.  The whole thing has to be done by using LOOP and ARRAY. You do not have to use User Defined function (UDF) for this question (But I would not mind if you decided to use UDFs.) Create a C script that 1. will prompt the user for the value of "n". The "n" is the number of the sides in a shape. 2. Then, the script should prompt the user prompt the user “n” times or “n x 2” times for (x, y) value of each vertex of the shape. 3. Then, compute the distance between adjacent vertices, then show!.4. Also, compute the average distance.5. Also, compute the median distance.6. Also, show the shortest distance and the longest distance.      Output Sample 1 (For this, distances are between (vertex 1 and vertex 2), between (vertex 2 and vertex 3 ), and between (vertex 3 and vertex 1)   Output Sample 2 (For this, distances are between (vertex 1 and vertex 2), between (vertex 2 and vertex 3 ), between (vertex 3 and vertex 4 ), and between (vertex 4 and vertex 1)     *Hint:  Say, we have a Hexagon (a shape with 6 sides, so n = 6). Distances between vertex 1 and vertex 2 between vertex 2 and vertex 3 between vertex 3 and vertex 4 between vertex 4 and vertex 5 between vertex 5 and vertex 6  can be computed by using a loop (by running the loop 5 times). Then, the distance between vertex 6 and vertex 1 can be placed in the array after the completion of the loop.    your_array = distance between vertex 6 and vertex 1     Distance formula between two points (X1, Y1) and (X2, Y2) :       

OBJECTIVE OF THIS QUESTION: TO TEST STUDENTS’ KNOWLEDGE ON the LOOP.    FOR THIS QUESTION, YOU ARE NOT TO USE POW() FUNCTION! YOU NEED TO USE A LOOP!  USE OF POW() FUNCTION  == ZERO FOR THIS QUESTION  You can compute Pth power of a base number B by multiplying the base number ‘B’ p-times. Ex) 34 = 3x3x3x3 Create a script that will 1. Prompt the user to type in the base number B and the Power P. 2. Compute BP. 3. Display the Result.    Please, use the following Demoshot as an Example!