2-Displaye the name Nd department number of all employees working indepartments 10 and 30 in alphabetical order of names.3-Displaye the name, function and salary of all employees whose functionis clerk or analyst and their salary is not eqaul $1000,$3000 or $50004-Display the name and salary of employees earning more than $2850.5-Display the name and salary of employees whose salary isn't includedbetween $1509 and $2850.6- Write a query that displays today's date. Name the column Date7-Display employee number, name, salary and salary plus 15% as aninteger. Name this column new salary8- for each employee displaye the name and calculate the number ofmonths between today and their hire date Name the column monthworked. sort the result in descending order of number months of work.Round the number of months to an integer9- write a query that displays the names of employees with the first letterin uppercase and the following in lower case, and the length of their nameand this for employees whose names begin with J, A, OR.M., give eachcolumn an appropriate title.10-Display the name of employees whose third letter of their name is an A.

According to the Bartleby guideline, we are supposed to answer only first 3 similar question at a…

2-Displaye the name Nd department number of all employees working in departments 10 and 30 in alphabetical order of names. 3-Displaye the name, function and salary of all employees whose function is clerk or analyst and their salary is not eqaul $1000,$3000 or $5000 4-Display the name and salary of employees earning more than $2850.

2-Displaye the name Nd department number of all employees working in departments 10 and 30 in alphabetical order of names. 3-Displaye the name, function and salary of all employees whose function is clerk or analyst and their salary is not eqaul $1000,$3000 or $5000 4-Display the name and salary of employees earning more than $2850.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 7RA

See similar textbooks

Similar questions

1.Display the seating capacity, fuel capacity, and miles per gallon for all aircraft manufactured by Boeing. Information about each equipment type should be displayed only once. I have tried this: SELECT EQUIP_TYPE.EQ_SEAT_CAPACITY, EQUIP_TYPE.EQ_FUEL_CAPACITY, EQUIP_TYPE.EQ_miles_per_galFROM EQUIP_TYPEWHERE EQ_EQUIP_NO IN (SELECT MIn( EQ_EQUIP_NO) FROM EQUIP_TYPE where EQ_EQUIP_TYPE LIKE 'BOE%' GROUP BY EQ_EQUIP_TYPE) However it returns the query back empty. I am unsure where i went wrong.
1. The main function creates 5 pixels with random red, green, and blue values. Complete the id_color function to return “red” if the red value is greater than the green and blue, “green” if the green value is greater than the red and blue, and “blue” if the blue value is greater than the red and green. If there is no clear maximum value (for example, if the red and green values are the same) return None. Do not change the main function.
Transcribed Image Text 4. To qualify for a particular scholarship, a student must have an overall grade point average of 3.0 or above and must have a science grade point average of over 3.2. Let overallGPA represent a student's overall grade point average and let scienceGPA represent the student's science grade point average. Which of the following expressions evaluates to true if the student is eligible for the scholarship and evaluates to false otherwise? A (overallGPA > 3.0) AND (scienceGPA > 3.2) (overallGPA > 3.0) AND (scienceGPA 2 3.2) C (overallGPA 2 3.0) AND (scienceGPA > 3.2) (overallGPA > 3.0) AND (scienceGPA 2 3.2)
Retrieve information from this webpage "https://www.chewy.com/b/dry-food-294", Dry Dog Food. The information you need is 1) the brand and the name of the products, 2) the price for auto ship, and 3) the regular price. For Q1 and Q2, you may need the function trimws() or gsub() to remove unwanted characters.
Retrieve information from this webpage "https://www.chewy.com/b/dry-food-294", Dry Dog Food. The information you need is 1) the brand and the name of the products, 2) the price for auto ship, and 3) the regular price. For Q1 and Q2, you may need the function trimws() or gsub() to remove unwanted characters. Can i have the code you use please
4. Create the getBestTime() function. The purpose of this function is to retrieve the user’s current best time tosolve the sliding block puzzle. Add the following code to the function:a. If the document.cookie object exists then i) Declare the cookieArray variable containing the text of thedocument cookie split at the occurrence of the "=" character. ii) Convert the cookie value to an integer byapplying the parseInt() function to the value of cookieArray[1] and return it from the function.b. If the document.cookie object does not exist, return a value of 9999.
v. Display only the StudentID, Programming Score and the Maths Score. vi. Show records of students with ID numbers from BIT2016003 to BIT2016005 vii. Select records of students who scored below 70 in Maths. viii. Insert the sixth record with Student ID=BIT2016006, First name =Gabriela, Surname = Yeboah, Maths =82, French=79 and Programming=58. ix. Select student(s) whose first name begins with the letter “J”. x. Delete student whose ID = BIT2016004 xi. Remove the surname column from the table xii. Change the French score to 79 for Student ID = BIT2016002 xiii. Remove the Student table from the database xiv. Remove MySchool database from the computer
Define a function named posterize. This function expects an image and a tuple of RGB values as arguments. The function modifies the image like the blackAndWhite function developed in Chapter 7 and shown below, but it uses passed in RGB values instead of black.
20.15 LAB: Interstate highway numbers Primary U.S. interstate highways are numbered 1-99. Odd numbers (like the 5 or 95) go north/south, and evens (like the 10 or 90) go east/west. Auxiliary highways are numbered 100-999, and service the primary highway indicated by the rightmost two digits. Thus, I-405 services I-5, and I-290 services I-90. Note: 200 is not a valid auxiliary highway because 00 is not a valid primary highway number. Given a highway number, indicate whether it is primary, auxillary, and what direction(s) it travels. Python
In PYTHON Print values from the Goal column only Print values only for columns: Team, Yellow Cards and Red Cards Find and print rows for teams that scored more than 6 goals Select the teams whose name start with a G Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain Find and print rows for teams that scored more than 6 goals and at least 4000 passes
In cell F7, create a formula that calculates the salary for Joan Dickinson. Her salary is calculated by adding her base salary (cell B7) to her total bonus (cell E7). (Hint: Do not use the SUM function.) To calculate the salary for all of the employees, copy the formula you created and the formatting in cell F7 into the range F8:F10. Kelly wants to view employees’ bonuses as a percentage of their base salary. In cell G7, enter a formula without using a function that divides Joan’s total bonus (cell E7) by her base salary (cell B7).
In PYTHON Print values from the Goal column only Print values only for columns: Team, Yellow Cards and Red Cards Find and print rows for teams that scored more than 6 goals Select the teams whose name start with a G Print values only for columns Team and Shooting Accuracy , and only for rows in which the team is either of the following: England, Italy and Spain Find and print rows for teams that scored more than 6 goals and at least 4000 passes Team Goals Shots on target Shots off target Shooting Accuracy Goals-to-shots (perc) Total shots (inc. Blocked) Hit Woodwork Penalty goals Penalties not scored Headed goals Passes Passes completed Passing Accuracy Touches Crosses Dribbles Corners Taken Tackles Clearances Interceptions Clearances off line Clean Sheets Blocks Goals conceded Saves made Saves-to-shots ratio Fouls Won Fouls Conceded Offsides Yellow Cards Red Cards Subs on Subs off Players Used Croatia 4 13 12 0.5 0.16 32 0 0 0 2 1076 828 0.769 1706 60…