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:
   88   89   90   91   92   93   94   95   96   97   98