The following statement uses a non-correlated subquery to find the South American country with the smallest population: SELECT * FROM Country WHERE Continent = 'South America' AND Population = (SELECT MIN(Population) FROM Country WHERE Continent = 'South America')\G Rewrite the statement to use a correlated subquery.

You can use relational operators to compare two DateTime objects and determine which one is earlier or later. Question 46 options:   True   False

File Name: Surname_MP8.m Problem Statement: Based on an automobile's model year and weight the state of New Jersey determines the car's weight class and registration fee using the following schedule: Model Year 1970 or earlier 1971 to 1979 1980 or later Weight Less than 2700 lbs 2700 to 3800 lbs More than 3800 lbs. Less than 2700 lbs 2700 to 3800 lbs More than 3800 lbs Less than 3500 lbs Weight Class 1 2 3 4 5 6 7 Registration Fee $ 16.50 25.50 46.50 27.00 30.50 52.50 19.50 3500 or more lbs 8 52.50 Using this information, write a MATLAB program (using Switch statement) that accepts the year and weight of an automobile and determines and displays the weight class and registration fee for the car.

Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted bythe Num_Shares column in ascending order.

Which of the following statements is correct to display all the columns from the weather table but only for whose humidity is in the range of 40 to 65? O a. SELECT * FROM weather WHERE humidity IN (40 ,65); 1 O b. SELECT * FROM weather WHERE humidity NOT IN (40 AND 65); O c. SELECT * FROM weather WHERE humidity NOT BETWEEN 40 AND 65; O d. SELECT * FROM weather WHERE humidity BETWEEN 40 AND 65; Different employees joined a company on same date. You want to display the hire date and count of the employees in each hire date group. Query 1: Select hiredate, count(*) from employee group by hiredate; Query 2: Select hiredate , count(hiredate) from employee order by hiredate; Which among the above two queries is valid? a. Both Query1 and Query2 are invalid O b. Query1 is valid O c. Both Query 1 and Query2 are valid d. Query2 is valid If a table PRODUCT has 2 columns namely PRODUCTID, PRODUCTNAME and a table ORDER has 3 columns namely ORDERID, ORDERAMOUNT and PRODUCTID. Which column can join…

INPUT TABLE You're given a orders table and the columns in the orders table are shown below: Orders Order_Id INT Type VARCHAR(10) Red_Shipping_ Days INT Scheduled_Shipping_Days INT Customer_Id INT Order _city VARCHAR(20) Order_Date DATE Order_Region VARCHAR(15) Order_State VARCHAR(20) Order _Status VARCHAR(20) Shipping_Mode VARCHAR(20)   QUERY Calculate count of all the orders. Where Order_ State is Maharashtra Note - Use the alias of oc for count of orders Group the results by Type Order them by oc in ascending order.   OUTPUT COLUMNS oc, Type

Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence