SSK3408 Lab Practice 4 First Semester 2021-2022 K9Lab Practice 41. Display the employee id, their first names and last names joined together, the length of theemployee last name, and the numeric position of the letter a in the employee last name forthose whose last names end with the letter n.2. Write a query to display the current date. Label the column Date.3. Write a query to display the last name and the number of weeks employed for all employees indepartment 60. Round the weeks into nearest total weeks.4. The HR department needs a report to display the employee number, last name, salary and salaryincreased by 15.5% (expressed as a whole number) for each employee. Label the column NewSalary. Hint : use Round Function5. Add a column that subtracts the old salary from the new salary. Label the column Increase.6. Write a query that displays the last name (with the first letter uppercase and all other letterslowercase) and the length of the last name for all employees whose name starts with the lettersJ, A or M. Give each column an appropriate label. Sort the results by the employees' last names.7. The HR department wants to find the length of employment for each employee. For eachemployee, display the last name and calculate the number of months between today and thedate on which the employee was hired. Label the column MONTHS_WORKED. Order yourresults by the number of months employed. Round the number of months up to the closestwhole number.8.Create a query to display the last name and salary for all employees. Format the salary to be 15characters long, left-padded with the $ symbol. Label the column SALARY.9. Create a query that displays the employees' last names and commission amounts. If anemployee does not earn commission, show 0. Label the column COMM. Hint : use NVL

As per out guidelines, we are supposed to answer only one question. Kindly repost the remaining…

1. Display the employee id, their first names and last names joined together, the length of the employee last name, and the numeric position of the letter a in the employee last name for those whose last names end with the letter n.

1. Display the employee id, their first names and last names joined together, the length of the employee last name, and the numeric position of the letter a in the employee last name for those whose last names end with the letter n.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Complete the following statement to create a table named Country. Choose data types based on the following requirements: • ISOCode3 stores the country's code, consisting of one to three letters. Name stores the country's name up to 52 characters. /* Your code goes here */ ( ISOCode 3 /* Your code goes here */ /* Your code goes here */ ); Name Enter a statement to delete the above table. /* Your code goes here */ ;
Determine which categories are covered by the existing book stock. There should only be one listing for each category.
Country ISOCode3 Name PopDensity NIC MLT Nicaragua Malta 140 3920 LBN Lebanon 1730 Complete the UPDATE statement to change 140 to 5220 in the Country table. In the WHERE clause, identify the row to be changed using the Name column. UPDATE Your code here */ SET WHERE Note: Your answers for SET and WHERE should include the column names followed by an equals sign and the corresponding value.
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
8. Display the book title and category for all books in the Children and Cooking categories.Create three different queries to accomplish this task: a) a search pattern operation, b) alogical operator, and c) another operator not used in a or b.
Jump to level Complete the following statement to create a table named Country. Choose data types based on the following requirements: ISOCode3 stores the country's code, consisting of one to three letters. • IndepDate stores the country's independence date. CREATE TABLE Country ); ( ISOCode 3 /* Your code goes here */ IndepDate /* Your code goes here */ Enter a statement to delete the above table. /* Your code goes here */ ;
4. Display a list of all book titles and the percentage of markup for each book. The percentageof markup should be displayed as a whole number (that is, multiplied by 100) with nodecimal position, followed by a percent sign (for example, .2793 = 28%). (The percentageof markup should reflect the difference between the retail and cost amounts as a percent ofthe cost.) SQL commands
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
8. Use the Form Wizard to create a new form for inputting sales data. Include all the fields from the PopcornSales table. a. b. Include the Item and Quantity fields from the SaleDetails table. c. View the form data by records in the PopcornSales table with related records in the SaleDetails table displayed in a subform. d. The subform should be displayed as a Datasheet. e. Name the main form: PopcornSales Form and name the subform: SaleDetailsSubform (Hint: Be sure to remove the space between ure.com/courses/79665/assignments/1378308?module_item_id=3226669 f. g. Access 365/2021 Capstone - SIMnet SaleDetails and Subform in the subform name suggested by Access.) Open the form in Form view to review your work. Navigate to the record in the main form for SaleID 3 and enter sale details in the subform as follows: Item: Truffle, Quantity: 3 Item: Old Bay, Quantity: 2 h. Close the form.
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending).
Country ISOCode3 Name PopDensity FJI Fiji 130 CHE LTU Switzerland 560 Lithuania 120 Complete the UPDATE statement to change 'Fiji' to 'North Macedonia' in the Country table. In the WHERE clause, identify the row to be changed using the PopDensity column. UPDATE Country SET WHERE Note: Your answers for SET and WHERE should include the column names followed by an equals sign and the corresponding value.
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.