Skip to content

This SQL query returns the last name, first name, student ID, and class ID of students with the first name 'Thomas' who are enrolled in 'COMPSCI101'. It filters results based on these conditions using a WHERE clause.

Notifications You must be signed in to change notification settings

xzebcex/Filtered-Student-Information

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Filtered Student Information

Description

This SQL query returns the last name, first name, student ID, and class ID of students with the first name 'Thomas' who are enrolled in 'COMPSCI101'. It filters results based on these conditions using a WHERE clause.

Instructions

Just copy and paste this query into your preferred PostgreSQL database administration tool, such as pgAdmin or the psql command line tool, to utilize it. Make sure you have a table called "students" with columns for last name, first name, student ID, and class ID.

Output

This query will return a table containing the last name, first name, student ID, and class IDs of all students who meet the criteria.

About

This SQL query returns the last name, first name, student ID, and class ID of students with the first name 'Thomas' who are enrolled in 'COMPSCI101'. It filters results based on these conditions using a WHERE clause.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published