1. īƼ¼Ç °ö, µ¿µîÁ¶ÀÎ, ÀÚ¿¬Á¶ÀÎ, ¿ÞÂʿܺÎÁ¶ÀÎ, ¿À¸¥ÂʿܺÎÁ¶Àο¡ ´ëÇØ ¼³¸íÇ϶ó
2. °ü°è´ë¼ö¿¡¼ ÁýÇÕ ¿¬»êÀÚÀÇ È£È¯¼º(compatibility)¿¡ ´ëÇØ ¼³¸íÇØ º¾½Ã´Ù.
3. SQLÀÇ SELECT ±¸¹®Àº °ü°è ´ë¼öÀÇ SELECTION°ú´Â ´Ù¸£´Ù. ±× Â÷ÀÌÁ¡À» »ý°¢ÇØ º¾½Ã´Ù.
4. ±âº» À妽º¿Í º¸Á¶ À妽ºÀÇ À¯»çÁ¡°ú Â÷ÀÌÁ¡À» ¼³¸íÇ϶ó
5. INSURED_AUTOS Å×À̺íÀº º¹ÇÕ ¾ÖÆ®¸®ºäÆ® (YEAR, MAKE, MODEL)¿Í ´ÜÀÏ ¾ÖÆ®¸®ºäÆ® (VIN)¿¡ À妽º°¡ Á¤ÀǵǾî ÀÖ´Ù. ´ÙÀ½ SELECT¹® Áß¿¡¼ À̵é À妽ºÀÇ ÇýÅÃÀ» º¸Áö ¸øÇÏ´Â °ÍÀº ù ¹ø° ÀÌ´Ù. ±× ÀÌÀ¯¿Í ³ª¸ÓÁö 2~4¹øÀº ¿Ö À妽º ÀÌ¿ëÀÌ °¡´ÉÇÑ Áö ¼³¸íÇ϶ó
¨ç select vin from insured_autos where make=`Ford` and model=`Taurus`;
¨è select count(*) from insured_autos where make=`Ford` and year=1998;
¨é select vin from insured_autos where year=1998 and owner=`Dahlman`;
¨ê select min(year) from insured_autos where make=`Ford` and model=`Taurus`;
|