MYSQL…… SOLUTION 1. Display the name of week day when socks purchased. Sol :-  2. Display remainder after dividing price by qty Sol :-  3.  Display the discount amount...

PYTHON SOLUTION ….. Considering the above dataframe answer the following question by writing appropriatecommand in python pandas: Display complete data for China and India. Display Country, Population and BirthRate...

MYSQL SOLUTION QUERY SOLUTION CREATE DATABASE CREATE TABLE STAFF and INSERT ALL THE RECORD.  SOL1  :- Display the difference of maximum and minimum salary of each section. SOL2 :-...

DATAFRAME IN PANDAS SOLUTION….. Considering the above dataframe answer the following queries by writing appropriate command in python pandas. i. Add a new column named discount which is 10%...

MYSQL SOLUTION Write SQL statements for the following based on table Garments: Create above table in MySQL. Insert records. To display the detail of class XII students in descending...

PYTHON…. SOLUTION….. Create a dataframe using lists.                                    Display books for class XII. ...

PYTHON….. SOLUTION…… import pandas as pd # Empty list to store marks std_marks = # Input marks of 10 students for i in range(1, 11): m = int(input(f"Enter...

PYTHON….. NOTES Introduction to Dictionary in Python (Detailed Explanation) In Python, a dictionary is a powerful and flexible built-in data structure designed to store data in the form of...

LIST IN PYTHON NOTES Introduction to List in Python (Expanded Theory) In Python, a list is one of the most important and commonly used built-in data structures. A list...