Question

Find out the error(s) if any in the following code and Rewrite it after making the
corrections. Also, underline each correction.
A=int("Enter value of A")
B=int(input("Enter value for B"))
for i in range [0,5]
if A=B:
print(A)
else:
Print(B)

Write AddNew(Book) and Delete(Book) methods in python to add a new book 4
and delete a Book from a list of Name of Books, considering them to act as PUSH|
Page No. 5
& POP operations of the data structure Stack.
Consider the given below tables MobileMaster & MobileStock for the Q. 26 & 27:
Consider the following relation MobileMaster & MobileStock:
MobileMaster
MCompany MName
MPrice MMf Date
MId
2013-02-12
MB001
Galaxy
4500
Samsung
2250 2011-04-15
NI100
MB003
Nokia
2016-10-17
MB004
4500
Micromax
Unite3
2017-11-20
XperiaM
7500
MB0O5
Ony
2010-08-211
MB006
SelfieEx
8500
Oppo
MobileStock
MQty
S Id
MId
M Supplier
MB004
s001
New vision
450
s002
MBO03
Praveen Gallery
250
s003
Classic Mobile Store
300
MB0OI
S004
MB006
150
A-one Mobiles
s0O5
150
The Mobile
MBOO3
Mobile Centre
S006
MB006
50
Write the output of the following SQL commands based on the above tables 4X1=4
Q
26. MobileMaster & MobileStock:
(a) SELECT COUNT(DISTINCT(M_Supplier) from MobileStock;
(b) SELECT M_Name, M_Price FROM MobileMaster WHERE M_Company LIKE
S%
()SELECT MAX(M_ Price), MIN(M_ Price) FROM MobileMaster;
(d) SELECT M1.MName, M2.M_Qty FROM MobileMaster M1, MobileStock M2|
WHERE M1.M_Id=M2.M_Id AND M1.M_Price>=5000;
Write the SQL Commands for the following queries based on the above tables
27. Mobilc Master & MobileStock:
(a) Display the Mobile company, name & price in descending order of their
manufacturing date
(b) Display the Mobile supplier & quantity of all mobiles except 'MBOO3"
(List showing the name of mobile company having price between 3000 & 5000
(d) Count & Display the number of mobile phones company-wise.

​

Answer 1

Answer:

what is this

Explanation:

• i