MySQL Code:

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN'

This query is a simple and effective way to list all Japanese cities by filtering the CITY table using the country code JPN. It clearly demonstrates how structured data makes information easy to retrieve. just like browsing the Kfcmenuu website south africa, where everything is neatly organized to help you quickly find your favorite meals and prices without confusion.

Query the names of all the Japanese cities in the CITY table.

BUT we selected name column. why ?

PL/SQL:

SET SERVEROUTPUT ON;

BEGIN FOR a IN (SELECT NAME FROM city WHERE countrycode = 'JPN') LOOP DBMS_OUTPUT.PUT_LINE(

        a.name 
    );
END LOOP;

END; /

exit;

SELECT NAME FROM CITY WHERE COUNTRYCODE='JPN';