Q2. A Railway company uses machines …

Q2. A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: 46 16 Table Name: Machine Field Data Type Machine_ID Station CHAR (3) CHAR (30) Table Name: Sales Field Data Type Machine_ID CHAR (3) Date Tickets Sold DATE INTEGER Income DECIMAL (8,2) 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 ( ID = 122 till date.

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

Information technology (code no)pre- broad exam

What is the function of def()?

Write a python program to calculate perimeter of rectangle

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

Import math ceil

Whate is global scope

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

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.

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.