SALARY oduction 45000 HR 70000 anagemer 120000 67000 145000 EMPNO EMP_NAME DEPT E101 Amit E102 Amit E103 sunita E105 sunita IT E106 mahesh Civil DOJ 12-Mar-00 03-Jul-02 11-Jan-01 mysore 01-Aug-01 mysore 20-Sep-03 Mumbai BRANCH Bangalore Bangalore Perform the following 1. Display all the fields of employee table 2. Retrieve employee number and their salary 3. Retrieve average salary of all employee 4. Retrieve number of employee 5. Retrieve distinct number of employee 5. Retrieve total salary of employee group by employee name and count similar names 7. Retrieve total salary of employee which is greater than >120000 3. Display name of employee in descending order 9. Display details of employee whose name is AMIT and salary greater than 50000;

SALARY oduction 45000 HR 70000 anagemer 120000 67000 145000 EMPNO EMP_NAME DEPT E101 Amit E102 Amit E103 sunita E105 sunita IT E106 mahesh Civil DOJ 12-Mar-00 03-Jul-02 11-Jan-01 mysore 01-Aug-01 mysore 20-Sep-03 Mumbai BRANCH Bangalore Bangalore Perform the following 1. Display all the fields of employee table 2. Retrieve employee number and their salary 3. Retrieve average salary of all employee 4. Retrieve number of employee 5. Retrieve distinct number of employee 5. Retrieve total salary of employee group by employee name and count similar names 7. Retrieve total salary of employee which is greater than >120000 3. Display name of employee in descending order 9. Display details of employee whose name is AMIT and salary greater than 50000;

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3RA

See similar textbooks

Similar questions

Aseed fde.
Students Courses Stu_Id Stu_Name Age GPA Course_Code Course_Name Cr_Hrs 201912346 Ali 20 2.5 ITDR2106 Introduction 3 to Database 201812347 Sami 22 3.0 ITDR3102 Operating Systems Programming 3 3 202022228 Yaser 21 2.3 ITDR2104 202011119 Yumna 23 2.7 202011110 Turkiya 23 2.9 202011111 Raya 22 2.5 Display the students name's whose names ends with 'Y'.
Suppose that you are given a database that records information about human resources of a large multi-national company. You can find the enhanced en- tity relationship diagram of this database below. Answer the following question by writing am SQL query on this database. You are given an example output for the question. Records with '9999-01-01’ as their to date attribute are the current ones. salaries employees titles emp_no INT(11) emp_no INT(11) emp_no INT(11) salary INT(11) O birth_date DATE %23 title VARCHAR(50) from_date DATE first_name VARCHAR(14) from_date DATE to_date DATE last_name VARCHAR(16) O to_date DATE Indexes gender ENUM(M', F) Indexes PRIMARY hire_date DATE PRIMARY PRIMARY dept emp emp_no INT(11) dept_manager Kdept_no CHAR(4) O from_date DATE emp_no INT(11) departments dept_no CHAR(4) dept_no CHAR(4) to date DATE O from_date DATE O dept_name VARCHAR(40) KIndexes O to_date DATE Indexas PRIMARY Indexes PRIMARY dept_no PRIMARY dept_name dept no Find the first names and…
Employee.tx Kent Brockman 12345Charles Burns 24923Cletus Delroy 25394Ned Flanders 04382Seymour Skinner 45234Homer Simpson 62352Milhouse Vance 52352Nelson Muntz 63265Edna Krabapple 72353Jimbo Jones 10234Martin Prince 02532Patty Bouvier 23252Troy McClure 32522Marvin Monroe 10028Waylon Smithers 80214Moe Szyslak 13095Clancy Wiggum 23052John Frink 20625Barney Gumbel 11321Julias Hibbert 13359Lionel Hutz 21952Helen Smith 19202Bill Clinton 79872Alexander Hamilton 92321John Wynne 23421YourFirstName YourLastName YourZipCode
Branch branchNo street city postcode sWI 4EH 16 Argyll St Aberdeen AB2 3SU GI1 9QX BO05 22 Deer Rd London BO07 BO03 163 Main StGlasgow BO04 32 Manse Rd Bristol BS99 INZ BO02 56 Clover Dr London NW10 6EU Foreign key Staff staffNo fName IName| position salary branchNo sex DOB SL21 John White Manager Assistant M 1-Oct-45 30000 BO05 SG37 Ann Beech 10-Nov-60 12000 вооз SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant 19-Feb-70 9000 BO07 SG5 Susan Brand Manager 3-Jun-40 24000 BO03 SLA1 Julie Lee Assistant 13-Jun-65 9000 BO05 Tuple Degree Candidate Key Cardinality Domain Attributes Drag and drop the proper terms Relation Relation
BookId Title PublisherName DatePublished B1 Himu Onnyoprokash 1997 B2 Ami Topu Ananya 2005 B3 Ma Pearl 2003 B4 Harry Potter Times 1995 B5 Machine Learning Dimik 2018 BookId AuthorName B1 Humayun Ahmed B2 Jafar Iqbal B3 Anisul Haque B4 JK Rowling B5 Nafis Neehal PublisherName Address Phone Onnyoprokash Nilkhet 9153752 Ananya Mohammadpur 8163743 Pearl Dhanmondi 2163856 Times London 4234714 Dimik Azimpur 4644454 BookId BranchId NoOfCopies B1 Br1 10 B2 Br2 20 B3 Br3 05 B4 Br2 07 B5 Br3 11 BranchId BranchName Address Br1 Shokal Mohakhali Br2 Dupur Uttara Br3 Shondha Moghbazar Find the books published before 2008. Find the book names authored by JK Rowling. Show the phone numbers of publishers which published the book of Anisul Haque…
question atatched
Patient Doctor P_Id P_Name Gender Age 1 Aqib Male 25 2 Saima Female 36 3 Fatima Female 29 4 Nouman Male 31 5 Muneeb Male 40 6 Tariq Male 38 7 Ikram Male 26 8 Sadia Female 27 D_Id D_Fname D_Lname Salary City 1 Laiba Hafeez 50000 Rwp 2 Sameer Khan 80000 Isb 3 Talib Ali 62000 Isb 4 Saleem Iqbal 77000 Multan 5 Tania Abbas 85000 Lahore 6 Huda Ahmad 68000 Rwp Write SQL queries for the following. Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator. Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator. Display details of those doctors who neither…
Patient Doctor P_Id P_Name Gender Age 1 Aqib Male 25 2 Saima Female 36 3 Fatima Female 29 4 Nouman Male 31 5 Muneeb Male 40 6 Tariq Male 38 7 Ikram Male 26 8 Sadia Female 27 D_Id D_Fname D_Lname Salary City 1 Laiba Hafeez 50000 Rwp 2 Sameer Khan 80000 Isb 3 Talib Ali 62000 Isb 4 Saleem Iqbal 77000 Multan 5 Tania Abbas 85000 Lahore 6 Huda Ahmad 68000 Rwp Write SQL queries for the following. Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator. Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator. Display details of those doctors who neither…
Patient Doctor P_Id P_Name Gender Age 1 Aqib Male 25 2 Saima Female 36 3 Fatima Female 29 4 Nouman Male 31 5 Muneeb Male 40 6 Tariq Male 38 7 Ikram Male 26 8 Sadia Female 27 D_Id D_Fname D_Lname Salary City 1 Laiba Hafeez 50000 Rwp 2 Sameer Khan 80000 Isb 3 Talib Ali 62000 Isb 4 Saleem Iqbal 77000 Multan 5 Tania Abbas 85000 Lahore 6 Huda Ahmad 68000 Rwp a) Write SQL queries for the following. 1) Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator. 2) Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator. 3) Display details of those doctors who neither belong to Isb nor Rwp nor Multan without using in and like operator. 4) Display full name of doctors whose first name is…
Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…
Use html, php and Mysql to design a Library Managment web based System The system should be able to do the following:1) Add/Remove/Edit book2) Search Catalog3) Register new account/ cancel membership4) Check-out book5) Reserve book6) Renew a book7) Return a book Three main users for the system:1) Librarian2) Member3) System