Please select a subject first
Advertisements
Advertisements
Write outputs for SQL queries that are based on the given table PURCHASE:
| TABLE: PURCHASE | ||||
| CNO | CNAME | CITY | QUANTITY | DOP |
| C01 | GURPREET | NEW DELHI | 150 | 2022-06-11 |
| C02 | MALIKA | HYDERABAD | 10 | 2022-02-19 |
| C03 | NADAR | DALHOUSIE | 100 | 2021-12-04 |
| C04 | SAHIB | CHANDIGARH | 50 | 2021-10-10 |
| C05 | MEHAK | CHANDIGARH | 15 | 2021-10-20 |
- SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
- SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
- SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;
Concept: Functions in SQL
Based on the table STUDENT given here, write suitable SQL queries for the following:
| Roll No | Name | Class | Gender | City | Marks |
| 1 | Abhishek | XI | M | Agra | 430 |
| 2 | Prateek | XII | M | Mumbai | 440 |
| 3 | Sneha | XI | F | Agra | 470 |
| 4 | Nancy | XII | F | Mumbai | 492 |
| 5 | Himanshu | XII | M | Delhi | 360 |
| 6 | Anchal | XI | F | Dubai | 256 |
| 7 | Mehar | X | F | Moscow | 324 |
| 8 | Nishant | X | M | Moscow | 429 |
- Display gender-wise highest marks.
- Display city-wise lowest marks.
- Display the total number of male and female students.
Concept: Functions in SQL
Discuss the significance of Group by clause in detail with the help of a suitable example.
Concept: GROUP BY Clause in SQL
Write suitable SQL query for the following:
Display 7 characters extracted from the 7th left character onwards from the string ‘INDIA SHINING’.
Concept: Functions in SQL
Write suitable SQL query for the following:
Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.
Concept: Functions in SQL
Write suitable SQL query for the following:
Round off the value 23.78 to one decimal place.
Concept: Functions in SQL
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Concept: Functions in SQL
Write suitable SQL query for the following:
Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.
Concept: Functions in SQL
Explain the following SQL function using a suitable example.
UCASE()
Concept: Functions in SQL
Explain the following SQL function using a suitable example.
TRIM()
Concept: Functions in SQL
Explain the following SQL function using a suitable example.
MID()
Concept: Functions in SQL
Explain the following SQL function using a suitable example.
DAYNAME()
Concept: Functions in SQL
Explain the following SQL function using a suitable example.
POWER()
Concept: Functions in SQL
Shreya, a database administrator has designed a database for a clothing shop. Help her by writing answers to the following questions based on the given table:
| TABLE: CLOTH | |||||
| CCODE | CNAME | SIZE | COLOR | PRICE | DOP |
| C001 | JEANS | XL | BLUE | 990 | 2022-01-21 |
| C002 | T-SHIRT | M | RED | 599 | 2021-12-12 |
| C003 | TROUSER | M | GREY | 399 | 2021-11-10 |
| C004 | SAREE | FREE | GREEN | 1299 | 2019-11-12 |
| C005 | KURTI | L | WHITE | 399 | 2021-12-07 |
- Write a query to display cloth names in lowercase.
- Write a query to display the lowest price of the clothes.
- Write a query to count the total number of clothes purchased in medium size.
OR
Write a query to count the year-wise total number of clothes purchased.
Concept: Functions in SQL
To display the last five rows of a series object ‘S’, you may write ______
Concept: A Series
Which of the following statement will import pandas library?
Concept: A Series
Which of the following can be used to specify the data while creating a DataFrame?
Concept: DataFrame
Assertion (A): DataFrame has both a row and column index.
Reasoning (R): A DataFrame is a two-dimensional labelled data structure like a table of MySQL.
Concept: DataFrame
Write a program to create a series of objects using a dictionary that stores the number of students in each house of class 12D of your school.
Note: Assume four house names are Beas, Chenab, Ravi, and Satluj having 18, 2, 20, and 18 students respectively and pandas library has been imported as pd.
Concept: A Series
What will be the output of the following code:
>>>import pandas as pd
>>>A = pd.Series(data = [35, 45, 55, 40])
>>>print(A > 45)Concept: A Series
