Sample Database with SQL Queries

This repository contains examples of SQL code used to create a sample database named "library" with a table named "books". It demonstrates various functionalities like data insertion, manipulation, and retrieval.

Functionality Examples:

-Creating the database and table structure -Inserting sample data into the table -Selecting all data from the table -Updating specific data in the table -Retrieving data based on criteria (publication year) -Finding distinct values in a column (genre) -Aliasing a column name (author to book author)