Table Personal Dobirth 23-Jan-1965 12.dec 1976 …

Table Personal Dobirth 23-Jan-1965 12.dec 1976 11-aug-1975 04-apr-1977 10-mar-1974 25-oct-1951 Table Job App date 25-fan-2006 22.dec 2006 19-aug-2007 14-apr:2004 13-mar-2008 Salary 5500 8500 7500 Empno 123 127 124 125 128 129 Name Amit Manoj Abhai Vinod Abhay Ramesh Native place Delhi Mumbai Allahabad Delhi Mumbai Pune Hobby Music Writing Music Sports Gardening Sports Dept Marketing Finance Marketing Sales Sales Sno 123 127 124 125 128 Area Agra Mathura Agra Delhi Pune Retd date 25-jan-2126 22-dec-2126 19-aug-2027 14-apr-2018 13-mar-2028 1. Show empno, name and salary of those who have Sports as hobby 2 Show name of the eldest employee. 3 Show number of employee area wise Show youngest employees from each Native place. 5 Show Sto, Name. Hobby and Salary in descending order of Salary 6 Show the hobbies of those whose name pronounces as 'Abhay 7. Show the appointment date and native place of those whose name starts with or ends in d. 8. Show the salary expense with suitable column heading of those who shall retire after 20-jan-2016. Show additional burden on the company in case salary of employees having hobby as spo increased by 10% 10 Show the hobby of which there are 2 or more employees nth of service is 20 years
  • 0 answers

Related Questions:

What is spreadsheet
  • 0 answers
Computer science old slybuss?2021
  • 0 answers
Describe ARPANET
  • 0 answers
Full from of ssh
  • 2 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

CBSE Test Generator

Create papers in minutes

Print with your name & Logo

Download as PDF

3 Lakhs+ Questions

Solutions Included

Based on CBSE Blueprint

Best fit for Schools & Tutors

Work from Home

  • Work from home with us
  • Create questions or review them from home

No software required, no contract to sign. Simply apply as teacher, take eligibility test and start working with us. Required desktop or laptop with internet connection