Maria is entering customer data for her web store business. We’re going to help her organize her data.Start by turning this list of customer first names into a list called first_names. Make sure to enter the names in this order:AinsleyBenChaniDepak

Use a UNION to create a list of all the employee's and customer's first names and last names ordered by the last name in descending order.

You have a database with a customers table. Here is a partial listing of the records:First_NameLast_NameMichelleSenseAlexisRodriguezFloraSatoYou also have a table of employees. Here is a partial listing of the records:First_NameLast_NameSamuelClementineAlexisRodriguezJabariReddyYou want to create a query that will not return “Alexis Rodriguez” as part of the results. You begin typing your query:SELECT First_Name, Last_Name FROM customers________SELECT First_Name, Last_Name FROM employeesWhat should you type in the blank space between the two queries? (Please type your answer all in upper case. Example: SELECT)

Multi File Programming QuestionWrite a query to insert any 7 records to the table 'Customers'The column names and data types are given below.Table Details:Table name: CustomersColumn Names:customer_id INT PRIMARY KEY,first_name VARCHAR (255) NOT NULL,last_name VARCHAR (255) NOT NULL,phone VARCHAR (25),email VARCHAR (255) NOT NULL,street VARCHAR (255),city VARCHAR (50),state VARCHAR (25),zip_code VARCHAR (5)Note:Table names are case-sensitive.Customers table is already created in the backend.Input format :No Console InputOutput format :The Output prints the number of rows inserted.Sample test cases :Input 1 :Output 1 :count(*)7Note :The program will be evaluated only after the “Submit Code” is clicked.Extra spaces and new line characters in the program output will result in the failure of the test case.

When you create a table in a database, you need to identify a suitable name. In this case, you can call it "customers". 2. Based on 'CM Mobiles' requirements the customers table will have three columns: ● username ● full name ● email address3. The customer username contains alphanumeric values such as: Custom001, Custom002, and Custom003. Notice here that the username is always nine characters in length, so choose the CHAR datatype as it allows for a fixed length of characters. In this case, choose 9 characters, no more or less. Therefore you can declare the username in the SQL statement using the following SQL syntax:

Define a class named Customer that holds private fields for a customer ID number, last name, first name, and credit limit. Include four public functions that each set one of the four fields. Do not allow any credit limit over $10,000. Include a public function that displays a Customer’s data.a. Write a main()function in which you declare a Customer, set the Customer’s fields, and display the results.b. Write a main()function that declares an array of five Customer objects. Prompt the user for values for each Customer, and display all five Customer objects