Create a new IntelliJ Project $>$ HW$4($This can be a regular desktop application and

doesn't have to be a JavaFX project for this assignment. $)$

Add the jar file to your project.

Create a Java program that will show the results from the following queries on the

JavaBook database:

a$.$ All capital and state from the statecapital table.

b$.$ The title only, sorted alphabetically, for all courses in the course table with

exactly $3$ numOfCredits.

c$.$ Display the number of tuples in table student $($hint: count$()$ function in SQL$)$

d$.$ Display the firstName, lastName, birthDate for the student table for any

student who lives in zipcode $31411$ or $31435$

e$.$ Display coursed, subjectld, courseNumber, title, lastName for all faculty

who have taught a course. $($Hint: you will need to use tables faculty, course,

taughtby to determine the tuples to display$)$

My output

Driver loaded

Database connected

Capital State

Atlanta Georgia

Austin Texas

Indianapolis Indiana

Springfield Illlinois

Sacramento California

Courses with $3$ credits

Database Administration

Database Systems Intro to Java II

Rapid Java Application

Reading

Number of rows in table student: $11$