Chapter 18, Problem 5QY

Hive table’s column, PERSON has an array value, [“jihee”, “jong”,“hemo”]. What function generate three records from the array value,[“jihee”, “jong”, “hemo”]?a. RECORDS(PERSON)b. EXPLODE(PERSON)c. LINES(PERSON)d. ROWS(PERSON)

Executing an UPDATE statement will return______.     the number of records updated     the set of records updated      the identifiers of updated records     NULL

Sql server 2019 Get a count of the records in InvoiceArchive, the column header should read Record Count.

("View all employees" function) If users click "View all employees" ( call program:view_employee.php), your program should(i) Retrieve all employees from TECH3740. EMPLOYEE table and list all employees in HTMLTABLE format(ii) If the salary is NULL, print it in red color.(iii) If Gender='M', print it in blue color. If Gender='F', print it in red color.(iv) Display the average salary of listed employees at the bottom of the employee table.(v) A statement "There are # employee(s) in the database." should be displayed above theemployee table, where # is the number of employees.

USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.

C# OR C++ PROGRAMMING LANGUAGE   USE C# LANGUAGE TO Create a simple Record Keeping ProgramThe program shall ask the user to choose betweenAdd DataDelete DataDisplay DataEndIf Add Data, the program will ask the user to enter a key and its valueEnter Key:Enter Value:Store all data in a dictionaryIf Delete Data, the program will ask for the key and remove the item from the dictionaryDisplay the content of the dictionary once the user selects Display DataIf End, display Thank you.

In Merge Sort Ascending Order (Data Structure)   Show the step by step process on how sorting was done such as first passed, second passed, etc. Please the details in the file.   Thank you.

Range controls and null value controls may improve or hinder data integrity.

C++ Write a program that will allow a user to enter students into a database. The student information should include full name, student ID, GPA and status. The program should allow delete any student based on student ID.