Informatics Practices
I. Write an SQL statement to create a table named STUDENTS, with the following specifications:
| Column Name | Data Type | Key |
|---|---|---|
| StudentID | Numeric | Primary Key |
| FirstName | Varchar(20) | |
| LastName | Varchar(10) | |
| DateOfBirth | Date | |
| Percentage | Float(10, 2) |
II. Write SQL Query to insert the following data in the Students Table
1, Supriya, Singh, 2010-08-18, 75.5
Answer
I.
CREATE TABLE STUDENTS (
StudentID NUMERIC PRIMARY KEY,
FirstName VARCHAR(20),
LastName VARCHAR(10),
DateOfBirth DATE,
Percentage FLOAT(10,2)
);
II.
INSERT INTO STUDENTS (StudentID, FirstName, LastName,
DateOfBirth, Percentage) VALUES (1, 'Supriya', 'Singh', '2010-08-18',
75.5);
Related Questions
Write a Python program to create the following DataFrame using a list of dictionaries.
No Product Price 0 Laptop 60000 1 Desktop 45000 2 Monitor 15000 3 Tablet 30000 Write a Python Program to create a Pandas Series as shown below using a dictionary. Note that the left column indicates the indices and the right column displays the data.
Russia Moscow Hungary Budapest Switzerland Bern Consider the following tables:
Table 1:
EMPLOYEE which stores Employee ID (EMP_ID), Employee Name (EMP_NAME), Employee City (EMP_CITY)
Table 2:
PAYROLL which stores Employee ID (EMP_ID), Department (DEPARTMENT), Designation (DESIGNATION), and Salary (SALARY) for various employees.
Note: Attribute names are written within brackets.
Table: EMPLOYEE
EMP_ID EMP_NAME EMP_CITY 1 ABHINAV AGRA 2 KABIR FARIDABAD 3 ESHA NOIDA 4 PAUL SEOUL 5 VICTORIA LONDON Table: PAYROLL
EMP_ID DEPARTMENT DESIGNATION SALARY 1 SALES MANAGER 75000 2 SALES ASSOCIATE 50000 3 ENGINEERING MANAGER 95000 4 ENGINEERING ENGINEER 70000 5 MARKETING MANAGER 65000 Write appropriate SQL queries for the following:
I. Display department-wise average Salary.
II. List all designations in the decreasing order of Salary.
III. Display employee name along with their corresponding departments.
Consider the following tables:
Table 1:
ATHLETE, which stores AthleteID, Name, Country. The table displays basic information of the athletes.
Table 2:
MEDALS, which stores AthleteID, Sport, and Medals. The table displays the number of medals won by each athlete in their respective sports.
Table: ATHLETE
AthleteID Name COUNTRY 101 Arjun INDIA 102 Priya INDIA 103 Asif UAE 104 Rozy USA 105 David DENMARK Table: MEDALS
AthleteID Sport Medals 101 Swimming 8 102 Track 3 103 Gymnastics 5 104 Swimming 2 105 Track 6 Write appropriate SQL queries for the following:
I. Display the sports-wise total number of medals won.
II. Display the names of all the Indian athletes in uppercase.
III. Display the athlete name along with their corresponding sports