Using Mysql

Connection name = elvis

Connection method : Standerd TCP/IP over SSH

SSH hostname : elvis.rowan.edu

DB : Sakila

#1. What is wrong with this query ? Explain what is wrong, write the correct query SELECT city, country, country_id FROM city a INNER JOIN country b ON a.country_id = b.country_id;

#2 What are the different types of JOIN in MYSQL and give a brief note about them (no diagrams / photos).

#3 Write a query to display First Name and Last Name of actors who acted in movie 'Ace Goldfinger' (clue: Actor, Film, Film_actor tables need to be used). You can use sub query or join or combination of both.

#4. Write a query to find the Total number of movies which has title starting with 'ch' and are 'R' rated.

#5. Write a query to find out how many customers are from Bursa ? (tables : customer, address)

#6. List of any 5 MySQL string functions.

#7. What are the commands to List of databases in MySQL.

List of Tables.

Display Current Version of MySQL.

Display logged in user.