Accounting information systems

Attached is a table called BILLING HOURS compiled from various data elements in Kenya Company's relational database. REQUIRED: (1) Using the attached form and proper SQL commands, develop a query to extract billing data for Fleet Services (client number F11555), showing the employee number, date, hours, and billing rate. (2) Using the attached form, design a table showing the output that would be generated based upon your query created in (1) above. KENYA COMPANY BILLING HOURS TABLE FROM RELATIONAL DATABASE \begin{tabular}{|c|c|c|r|r|} \hline Employee Number & Client Number & Date & \multicolumn{1}{|c|}{ Hours } & Billing Rate \\ \hline B122 & F11555 & 990823 & 8 & 150 \\ \hline A632 & F11555 & 990823 & 8 & 100 \\ \hline B122 & F11555 & 990824 & 8 & 150 \\ \hline A632 & F11555 & 990824 & 8 & 100 \\ \hline B122 & F11555 & 990825 & 8 & 150 \\ \hline A632 & F11555 & 990825 & 8 & 100 \\ \hline B122 & H12456 & 990826 & 8 & 150 \\ \hline A632 & H12456 & 990826 & 8 & 100 \\ \hline A356 & F11555 & 990826 & 8 & 57 \\ \hline A432 & H12456 & 990826 & 8 & 57 \\ \hline A491 & H12456 & 990826 & 8 & 57 \\ \hline B122 & F11555 & 990827 & 8 & 150 \\ \hline A632 & H12456 & 990827 & 8 & 100 \\ \hline A356 & F11555 & 990827 & 8 & 57 \\ \hline B432 & H12456 & 990827 & 8 & 57 \\ \hline B491 & H12456 & 990827 & 8 & 57 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|} \hline(1) & KENYACOMPANYSQLCOMMANDSTOODEVELOPQUERYFOREXTRACTINGBILLINGDATA \\ \hline & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & & \\ \hline & & & \\ \hline TABLE SHOWING OUTPUT CREATED FROM QUERY \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular}