Mr. Roper owns 20 apartment buildings. Each building contains 15 units that he rents for $800 per  month each. Design the application that would output 12 payment coupons for each of the 15  apartments in each of the 20 buildings. Each coupon should contain the building number (1 through  20), the apartment number (1 through 15), the month (January through December), the amount of  rent and rent due.

Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order.   (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)

Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

The APPT_DTTM column stores the date and time of an appointment. Which of the following expressions would return TRUE for all appointments on January 1, 2018, and FALSE for all other appointments? SELECT ONE OF THE FOLLOWING A. APPT_DTTM >= '1 JAN 2018' AND APPT_DTTM < '2 JAN 2018' B. APPT_DTTM = '1 JAN 2018' C. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM <= '1 JAN 2018' D. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM < '2 JAN 2018' Choose one correct answer and what is output of remaining queries with proper explanation

Check out the Unix/Linux commands ps and kill and their various options. a) Use the ps command to get a list of all your processes and save them in a log.txt file. At a minimum, the following 4 attributes should be recorded in the file for each process: name, process ID (PID), memory usage and CPU time. Attach the generated log file as an answer to this question. b) Open a terminal and get the PID of your editor process. Use the kill command to shut down the editor process. In your answer, show the commands you used to achieve the goal and explain what is what for each command. c) Write a C program that will start an editor process, get its PID, wait 3 seconds, and then terminate the editor process (You can use the exec family of system calls (man exec) to start any program or command from within a C program). d) Write a C program that will constantly monitor all processes (let's say once a second) and kill an editor immediately if it encounters an editor.

When should a subquery be nested in a HAVING clause?