Question
Rewrite the following code in Python after removing all syntax error(s). Underline each correction done in the code.
✓
Answer
Get the step-by-step solution for this question inside the Vidyadip app.
Get the answer in the appNeed 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
Differentiate between DDL &DMLcommands. Identify DDL &DML commands from the following:
(UPDATE, SELECT, ALTER, DROP)
Python program to generate groups of 6 consecutive numbers in a list.
Differentiate between Candidate Key and Alternate Key in context of RDBMS.
What kind of data gets stored in cookies and how is it useful?
WAP in python to create the duplicate copy of the list.
Differentiate between DDL & DMLcommands. Identify DDL & DML commands from the following:
(UPDATE, SELECT, ALTER, DROP)
Out of the following, which all comes under cyber crime?
- Stealing away a brand new hard disk from a showroom.
- Getting in someone's social networking account without his consent and posting on his behalf.
- Secretly copying data from server of a organization and selling it to the other organization.
- Looking at online activities of a friend's blog.
Find and write the output of the following Python code:
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;
Based on the following python code, find out the expected correct output(s) from the options (i) to (iv)
tup=("Red","Blue","Green","Yellow")
for i in range(3):
print(tup[random.randrange(1,4,2)],end="#")
(i) Blue#Blue#Yellow#
(ii) Red#Green#Green#
(iii) Blue#Yellow#Green# (iv) Blue#Green#Yellow#
tup=("Red","Blue","Green","Yellow")
for i in range(3):
print(tup[random.randrange(1,4,2)],end="#")
(i) Blue#Blue#Yellow#
(ii) Red#Green#Green#
(iii) Blue#Yellow#Green# (iv) Blue#Green#Yellow#