Consider the following relational schema and corresponding sample data: Classes (class, type, country, num Guns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) class type country numGuns bore displacement Bismarck bb Germany 8 15 42,000 Iowa bb USA 9 16 46,000 Kongo be Japan 8 14 32,000 North Carolina bb USA 9 16 37,000 Renown be Britain 6 15 32,000 Revenge bb Britain 8 15 29,000 Tennessee bb USA 12 14 32,000 Yamato bb Japan 18 65,000 name date Denmark Strait 05/24/41 Guadalcanal 11/15/42 North Cape 12/26/43 Surigao Strait 10/25/44 name class California Tennessee Haruna Kongo Hiei Kongo Iowa Iowa Kirishima Kongo Kongo Kongo Missouri Iowa Musashi Yamato New Jersey Iowa North Carolina North Carolina Ramillies Revenge Renown Renown Repulse Renown Resolution Revenge Revenge Revenge Royal Oak Revenge Royal Sovereign Revenge Tennessee Tennessee Washington North Carolina Wisconsin Iowa Yamato Yamato launched 1915 1915 1915 1933 1915 1913 1935 1942 1936 1941 1917 1916 1916 1916 1916 1916 1916 1915 1941 1940 1941 ship battle California Surigao Strait Kirishima Guadalcanal Resolution Denmark Strait Wisconsin Guadalcanal Tennessee Surigao Strait Washington Guadalcanal New Jersey Surigao Strait Yamato Surigao Strait Wisconsin Surigao Strait result ok sunk ok damaged ok ok ok sunk damaged SQL Relational Algebra form
List the name, displacement, and number of guns of the ships engaged in the battle ofSurigao Strait.
List the name of all the ships from the database. Ships appear inShips, Classes, andOutcomestables. All of them have to be printed.
Find the classes that have exactly two ships in the class.
Find the countries that have both bb and bc ships