Page 93 - IPP-12-2024
P. 93
mon=['March','April','May','June','July','August']
mask=[1500,3500,6500,6700,6000,6800]
san=[4400,4500,5500,6000,5600,6300]
hw=[6500,5000,5800,6300,6200,4500]
plt.plot(mon,mask,label='Mask',color='g',linestyle='dashed',linewi
dth=4,marker='o',markerfacecolor='k',markeredgecolor='r')
plt.plot(mon,san,label='Sanitixzer',color='b',linestyle='dashed',l
inewidth=4,marker='3',markerfacecolor='k',markeredgecolor='g')
plt.plot(mon,hw,label='Handwash',color='r',linestyle='dashed',line
width=4,marker='v',markerfacecolor='k',markeredgecolor='b')
plt.title("Fitwell Medical Store")
plt.xlabel("Months")
plt.ylabel("Covid Protections")
plt.legend()
plt.show()
Output:
Database query using MySQL
Program 20. Write the SQL Query for the following: