Skip to main content

GRADE XII - MYSQL JOIN QUERY ASSIGNMENT

 

MYSQL JOINS

Given Tables

Student(RollNo, Name, Class)

Marks(RollNo, Subject, Marks)

Questions

1. Write a query using Equi Join to display Student Name and Marks.

2. Write a query using Equi Join to display all columns from both tables where RollNo matches.

3. Write a query using NATURAL JOIN to display all matching records.

4. Write a query using NATURAL JOIN to display Name, Subject, and Marks.

5. Write a query to display all possible combinations of Student and Marks using Cartesian Product.

6. Write a query using Cartesian Product with WHERE condition to display only matching RollNo records.

7. Identify the type of JOIN used in: SELECT * FROM Student, Marks;

8. Predict the number of rows returned by: SELECT * FROM Student, Marks;

9. Write a query using Equi Join to display names of students who have marks greater than 85.

10. Write a query using NATURAL JOIN to display records of Class 12 students only.

11. Write a query using Equi Join to display RollNo, Name, and Subject.

12. Write a query using Cartesian Product and filter records where Subject is 'CS'.

13. Which column is automatically removed in NATURAL JOIN output and why?

14. Write a query using Equi Join to display students who have matching records in Marks table.

15. Write a query using NATURAL JOIN and arrange the result in descending order of Marks.

16. Write a query to count total number of rows produced by Cartesian Product.


Comments

Post a Comment

Popular posts from this blog

GRADE XII - Python Connectivity with MySQL

  Python Connectivity with MySQL In real-life applications, the data inputted by the user and processed by the application needs to be saved permanently, so that it can be used for future manipulation. Usually, input and output data is displayed during execution but not stored, as it resides in main memory , which is temporary — i.e., it gets erased once the application is closed. This limitation can be overcome by sending the data to be stored in a database , which is made accessible to the user through a Front-End interface . Key Concepts Database A database is an organized collection of data that is stored and accessed electronically from a computer system. DBMS (Database Management System) A DBMS is software that interacts with end-users, applications, and the database to capture and analyze data. Front-End The Front-End is the user interface of the application, responsible for input/output interaction with the user. Back-End The Back-End refe...
Post a Comment
Read more

GRADE XII - CSV FILE

CSV FILE (COMMA SEPERATED VALUE) CSV NOTES LINK :  CSV NOTES - CLICK HERE Writing data to a CSV file involves the following steps: Import the csv module Open the CSV file in write mode ( "w" ) using open() Create the writer object Write the data into the file using the writer object Close the file using close() writerow() Method This method is used to write a single row to a CSV file. It takes a sequence (list or tuple) as its parameter, and writes the items as a comma-separated line in the file. You do not need to add a newline character (\n) — it automatically places the end-of-line marker.     EXAMPLE 1: import csv  # Importing the csv module # CSV file opened using relative path csv_fobj = open("emp.csv", "w")   # Writer object created wtr_obj = csv.writer(csv_fobj) # Record with field heading is written wtr_obj.writerow(["Empno", "Name", "Salary"]) # Records with data are...
Post a Comment
Read more