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

Whate is global scope

Information technology (code no)pre- broad exam

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

• Don't post personal information, mobile numbers and other details.
• Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
• Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
• Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: Table Name: Machine Table Name: Sales The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. (b) Write a query to find the number of ticket machines in each station. (c) Write a query to find the total ticket income of the station “New Delhi” of each day. (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date.

Write a python program to calculate perimeter of rectangle

Write a program to accept a list of strings, display which as starting and ending letter to be same.

What is the function of def()?

a=[1,12,4,0,18,17,16] n=len(a) for i in range(1,0): key=a[I]: j=i_1 while j>=0 and key

Which of the following mode in file opening statement results or generates an error if the file does not exist?

Import math ceil