Q 15 Objective: Understanding the use …

Q 15 Objective: Understanding the use of String library methods. Task: Develop an application to Analyze the given string by counting the number of vowels, consonants, digits and spaces etc. Q16 Objective: Understanding the use of DML command at MySQL plateform. Task: Open MySQL and Login with your ID and password given by your Teacher. Write and Execute the SQL command for the following and also write the steps/commands in your Practical notebook. 1 Write commands to display the system date. 2 Write a command to display the name of current month. 3 Write command to print the day of the week of your birthday in the year 2015. 4 Write the command to round off value 15.193 to nearest ten’s i.e. 20. 5 Write a query to find out the result of 63. 6 Create and open Database named MYORG. 7 Create a table name Emp with following structure (EmpID Primary Kay) EmpID EmpName Designation DOJ sal comm Number Varchar Char(10) Date Number Number 8 Insert the following Records￾EmpID EmpName Designation DOJ Sal comm 8369 SMITH CLERK 1990-12-18 800.00 NULL 8499 ANYA SALESMAN 1991-02-20 1600.00 300.00 8521 SETH SALESMAN 1991-02-22 1250.00 500.00 8566 MAHADEVAN MANAGER 1991-04-02 2985.00 NULL 8654 MOMIN SALESMAN 1991-09-28 1250.00 400.00 8698 BINA MANAGER 1991-05-01 2850.00 NULL

Write a python program to plot aa bar chart showing the no. Of books published in respective year using the following data

Founder of python

Select round(6.5675,2);

what are aggregate function inSQL? Name any two

Display the details of all the employees whose value is null

Consider a given series,M1 write a program in python pandas to create the series

Consider the SchoolBus table given below: Rtno. Area_covered. Capacity. No of students. Distance. Transporter. Charges 1. Vasantkunj 100 120 10 Shivamtravels 100000 2. HauzKhas 80 80 10 Anand travels 85000 3. Pitampura 60 55 30 Anand travels 60000 4. Rohini 100 90 35 Anand travels 100000 5. Yamuna Vihar 50 60 20 Bhalla Co. 58000 6. Krishna Nagar 70 80 30 Yadav Co. 80000 7. Vasundhara 100 110 20 Yadav Co. 100000 8. PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

Write a program that generates the table of a input number using for loop

All data types of MySQL with example

List down the average of phone number what is the coding I couldn't remember