DATABASE Write down queries to apply left, Right, Inner, Full join.Table name: MembersIDFirst NameLast NameMovieAdamSmith1JohnWatson3SusanDavidson54JennyAdriana86.ElizabethWarren10Table name: MoviesMovie_IdTitleCategoryAssassin's CreedSci-Fi2The Shawshank RedemptionDramaThe Dark KnightAction4Forest GumpDrama5InceptionSci-FiThe MatrixAction7.InterstellarAdventure8.AllienHorrorPrestigeMystery10GladiatorDrama6.

Inner join will return the values from both the tables which satisfies the condition The query is :…

Write down queries to apply left, Right, Inner, Full join. Table name: Members ID First Name Last Name Movie_ld Adam Smith John Watson 3 Susan Davidson 5 Jenny Adriana 8 6. Elizabeth Warren 10 Table name: Movies Movie_ld Title Category Assassin's Creed Sci-Fi The Shawshank Redemption Drama The Dark Knight Action 4 Forest Gump Drama 5 Inception Sci-Fi 6. The Matrix Action 7. Interstellar Adventure Allien Horror Prestige Mystery 10 Gladiator Drama