Question
Find and write the output of the following Python code :
✓
Answer
Assuming that input value is 23
1
40
7
100
13
160
19
220
92
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
Write two advantages of 4G over 3G Mobile Telecommunication Technologies in terms of speed and services.
Write a program that reads a string and print and count the Upper case characters, Lower case characters and
other characters.
other characters.
Consider the following table Student & Stream.
Table: Student
| Admno | Sname | Class | Sec | Fee | Mobile | Area | S_ID |
| 1001 | RAMESH | XII | A | 2500 | 987654321 | Madipur | 10 |
| 1078 | KRISHNA | XII | B | 2400 | 999911111 | Jawala Heri | 30 |
| 1006 | FARDEEN | XII | C | 2600 | 987654321 | Paschim Puri | 40 |
| 1004 | SUBHAM | XII | A | 2500 | 963025874 | Madipur | 20 |
| 1029 | KRITIKA | XI | C | 2700 | 987456210 | Madipur | 30 |
| 1008 | SAMEEKSHA | XII | A | 2450 | 987123456 | Mangol Puri | 20 |
| 1025 | SALMA | XII | B | 2580 | 998877445 | Madipur | 30 |
| 1036 | AMANDEEP | XII | B | 2600 | 999333555 | Khyala | 40 |
| 1037 | TEJAS | XI | C | 2650 | 987951357 | Paschim Puri | 40 |
| 1029 | HIMANSHU | XII | A | 2750 | 951369874 | Jawala Heri | 10 |
Table : Stream
| S_ID | Stream_name |
| 10 | MEDILCAL |
| 20 | NON MEDICAL |
| 30 | COMMERCE WITH MATH |
| 40 | COMMERCE WITH IP |
| 50 | HUMANITIES |
Write SQL commands for the statements (a) to (h) on the table: Student and Stream
(a) Display class and total fee collected from each class.
(b) Display admission no, students name and stream name.
(c) Display all the student details who have taken Commerce Stream.
(d) Count number of students who have opted for HUMANITIES stream.
(e) Display information of commerce with ip students whose name start with ‘S’. Arrange the record by admission number.
(f) Display details of all students who are in the MEDICAL stream.
(g) Display total fee of ‘Non-Medical’ Student.
(h) Change the name of the Column Sname to Student_Name.
Write the output produced by the following SQL commands:
Categorise the following under Client Side and Server Side script category:
(i) VB Script
(ii) ASP
(iii) JSP
(iv) JavaScript
Write the output of the given program:
Write SQL queries for (a) to (d) and find outputs for SQL queries (e) to (i), which are based on the tables.
TABLE: WATCHES
| Watchid | Watch_name | Price | Type | Qty_store |
| W001 | High time | 10000 | Unisex | 100 |
| W002 | Life time | 15000 | Ladies | 150 |
| W003 | Wave | 20000 | Gents | 200 |
| W004 | High fashion | 7000 | Unisex | 250 |
| W005 | Golden time | 25000 | Gents | 100 |
TABLE: SALE
| Watchid | Qty_Sold | Quarter |
| W001 | 10 | 1 |
| W003 | 5 | 1 |
| W002 | 20 | 2 |
| W003 | 10 | 2 |
| W001 | 15 | 3 |
| W002 | 20 | 3 |
| W005 | 10 | 3 |
| W003 | 15 | 4 |
(a) To display all the details of those watches whose name ends with ‘time’
(b) To display watch’s name andprice of those watches which have price range between 5000-15000
(c) To display total quantity in store of unisex type watches
(d) To display watch name and their quantity sold in first quarter
(e) Select max(price),min(qty_store) from watches;
(f) Select quarter, sum(qty_sold) from sale group by quarter;
(g) Select watch_name,price,type from watches w, sale s where w.watchid=s.watchid;
(h) Select watch_name, qty_store, sum(qty_sold),qty_store
(i) W.watch=s.watchid group by s.watchid;
Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (vii), which are based on the tables.
Table: Trainer
| TID | Tname | City | HireDate | Salary |
| 101 | Sunaina | Mumbai | 1998-10-15 | 90000 |
| 102 | Anamika | Delhi | 1994-12-24 | 80000 |
| 103 | Deepti | Chandigarh | 2001-12-21 | 82000 |
| 104 | Meenakshi | Delhi | 2002-12-25 | 78000 |
| 105 | Richa | Mumbai | 1996-01-12 | 95000 |
| 106 | Maniprabha | Chennai | 2001-12-12 | 69000 |
Table: Course
| CID | CNAME | FEES | STARTDATE | TID |
| C201 | AGDCA | 12000 | 2018-07-02 | 101 |
| C202 | ADCA | 15000 | 2018-07-15 | 103 |
| C203 | DCA | 10000 | 2018-10-01 | 102 |
| C203 | DDTP | 9000 | 2018-09-15 | 104 |
| C205 | DHN | 20000 | 2018-08-01 | 101 |
| C206 | O LEVEL | 18000 | 2018-07-25 | 105 |
(a) Display the Trainer Name, City and Salary in descending order of their hire date.
(b) To display the TNAME and CITY of Trainer of joined the institute in the month of December 2001.
(c) To display TNAME, HIREDATE,CNAME, STARTDATE from tables TRAINER and COURSE whose FEES is less than or equal to 10000
(d) To display number of trainer from each city
(e) select tid, tname,from trainer where city not in(‘delhi’,’mumbai’);
(f) select distinct tid from course;
(g) select tid , count (*), min(fees) from course group by tid having count(*)>1;
(h) Select count(*),sum(fees) from course where startdate <’2018-09-15’;
Write script to find the sum of first n terms of the following series:
$1+x+\frac{x^2}{2}+\frac{x^3}{3}+\ldots$
where n and x have to be input from the user.
→$1+x+\frac{x^2}{2}+\frac{x^3}{3}+\ldots$
where n and x have to be input from the user.
Write script to find the sum of first n terms of the following series:
$x+x^2+x^3+\ldots$
where n and x have to be input from the user.
→$x+x^2+x^3+\ldots$
where n and x have to be input from the user.