your DB work $($code$,$ result, response AND DATE showing on your screen in the bottom right or top left$)$ and you upload the file as an MS Word or pdf$.$ MAKE SURE YOUR SQL SIZE IS $24($go to Edit, preferences, SQL$).$ Follow closely the template format $($see below$),$ and use it to submit your answer. Save this template under your $3$ Last names LastName$1\_$LastName$2\_$LastName$3,$ then submit it as a pdf on Canvas by the due date. You ONLY NEED TO ANSWER $1$ PROMPT $($according to your project group number$).$

Question: Find the SQL code for the following four business questions.

Business Question $1[$only for Group # from $1$ to $10$ AND from $31$ to $40]$:

The company would like to see how long its employees have been with the organization for over $15$ years as of $\frac{6}{01}\frac{?}{2022}.$ Create a query that provides the first name, last name, and the time with the company $($TimeWithCo$)$ for only those employees that are still with the organization. Make sure to show the longest tenured employees first.

Business Question $2[$only for Group # from $11$ to $20$ AND from $41$ to $50]$:

HR wants to send the completed budget reports to the various department managers. To do so$,$ they need a current listing of the department managers to contact. Keep in mind that not all the managers have the word "manager" in their title. For this query, the HR department needs the department name, manager first name, manager last name, and job title. The results must be sorted by department name and include the elements in the order listed.

Business Question $3[$only for Group # from $21$ to $30$ AND from $51$ to $61]$:

To help with anticipating the amount needed per employee for the cost$-$of$-$living stipends for those living in other countries, the HR department needs to know how many employees are living in each county. The employee count should only include active employees. The query results need to include the name of the country and the number of employees in that country $($NumberEmp$).$ The results need to be sorted by country name and include the elements in the order listed.

To receive total points on this project, the form must be completed in full, the results comply with the business question requests, and there is evidence that the query supplied will work and produce the results shown. $[$ see the Rubric in the assignment on Canvas$]$

It is advised for the students in the group fo re$-$download their submission from Canvas to make sure they uploaded the correct file. You may submit as many times as needed before the due date expires, so there is plenty of opportunities to practice this skill. The last submission provided before the deadline is the one to be graded.

All of the skills needed to complete these business questions are demonstrated in class and are available for "refresh" viewing in the LinkedIn Learning training, which you completed and got a certificate for, so I would encourage$-$the use of those resources to apply towards completing this project.

Submission Template

Pledge: "The contents of this file are of our work: $($full name of student $1,$ full name of student $2,$ full name of student $3).$ We$\text{'}$ did not give nor receive unauthorized assistance. We understand this was a group assignment whereby only reference materials provided or authorized by the instructor and meeting with him were permitted. We understand that violating this pledge is also a violation of the honor code. We understand that violation penalties will be a minimum of a zero on the assignment meaning a $10\%$ deduction on the overall total grade at the end of the semester along with the repeat forgiveness option for this course removed".

Student $1$ Signature: $($typed$)$

Student $2$ Signature: $($typed$)$

Student $3$ Signature: $($typed$)$

$$ Business question of your group typed$/$pasted here$>$

$<mn>1</mn>$ snippet$/$screenshot of DB Browser work $($will include code$+$ result$+$ response$+$ date$)>$

$+V+C,$ then control $+Von$ the Word doc underneath your code snippet$>$

NOTE: Don't forget $to$ GREATLY INCREASE $(suggested$ font size $24)$ the font $in$ the SQLite Browser $so$ that the codes will $be$ readable.

your DB work $($code$,$ result, response AND DATE showing on your screen in the bottom right or top left$)$ and you upload the file as an MS Word or pdf$.$ MAKE SURE YOUR SQL SIZE IS $24($go to Edit, preferences, SQL$).$ Follow closely the template format $($see below$),$ and use it to submit your answer. Save this template under your $3$ Last names LastName$1\_$LastName$2\_$LastName$3,$ then submit it as a pdf on Canvas by the due date. You ONLY NEED TO ANSWER $1$ PROMPT $($according to your project group number$).$

Question: Find the SQL code for the following four business questions.

Business Question $1[$only for Group# from $1$ to $10$ AND from $31$ to $40]$:

The company would like to see how long its employees have been with the organization for over $15$ years as of $\frac{6}{01}\frac{?}{2022}.$ Create a query that provides the first name, last name, and the time with the company $($TimeWithCo$)$