1. ã¯ããã«: SQLç°å¢æ§ç¯ã®éèŠæ§
çŸä»£ã®ããžãã¹ãåŠåã®å€ãã®åéã§ãããŒã¿ã¯äžå¿çãªåœ¹å²ãæãããŠããŸãããã®ããŒã¿ãå¹æçã«ç®¡çããåæããããã«ã¯ãé©åãªããŒã«ãæè¡ãå¿ èŠã§ããããã§ãSQLãšããèšèªãšãããã䜿çšããããã®ç°å¢æ§ç¯ã®éèŠæ§ã«ã€ããŠè§£èª¬ããŸãã
1.1 ããŒã¿ããŒã¹ãšã¯
ããŒã¿ããŒã¹ã¯ãæ å ±ãæŽçããŠä¿åããããã®ã·ã¹ãã ã§ããäŸãã°ããªã³ã©ã€ã³ã·ã§ããã³ã°ãµã€ãã®ååæ å ±ããSNSã®ãŠãŒã¶ãŒãããã£ãŒã«ãªã©ãç§ãã¡ãæ¥åžžçã«å©çšããå€ãã®ãµãŒãã¹ã¯ãè£åŽã§ããŒã¿ããŒã¹ãå©çšããŠæ å ±ã管çããŠããŸãã
ããŒã¿ããŒã¹ã«ã¯ããŸããŸãªçš®é¡ããããŸããããã®äžã§ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã¯æãäžè¬çã«äœ¿çšãããã¿ã€ãã§ãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã¯ãããŒãã«ãšãã圢åŒã§ããŒã¿ãä¿åããããããã®ããŒãã«ã¯è¡ãšåããæãç«ã£ãŠããŸãããã®ããŒãã«ã®åœ¢åŒããããŒã¿ã®æŽçãæ€çŽ¢ãéåžžã«å¹ççã«è¡ãããšãå¯èœã«ããŠããŸãã
1.2 SQLã®åœ¹å²ãšç¹åŸŽ
SQLïŒStructured Query LanguageïŒã¯ããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãæäœããããã®èšèªã§ããããŒã¿ã®è¿œå ãæŽæ°ãåé€ãæ€çŽ¢ãªã©ãããŒã¿ããŒã¹ã«é¢ããããŸããŸãªæäœãè¡ãããšãã§ããŸãã
SQLã®æ倧ã®ç¹åŸŽã¯ãéåžžã«çŽæçã§èªã¿ãããæ§æãæã£ãŠããããšã§ããäŸãã°ãããããŒãã«ããç¹å®ã®æ å ±ãååŸãããå Žåã”SELECT”ãšããããŒã¯ãŒãã䜿çšããŠç°¡åã«åœä»€ãæžãããšãã§ããŸãããã®ãããªçŽæçãªæ§æã®ãããã§ãåå¿è ã§ãçæéã§SQLã®åºæ¬çãªæäœãç¿åŸããããšãã§ããŸãã
2. SQLç°å¢æ§ç¯ã®åºæ¬ã¹ããã
SQLãå¹æçã«å©çšããããã«ã¯ããŸãé©åãªç°å¢ãæŽããããšãäžå¯æ¬ ã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãSQLã®ç°å¢æ§ç¯ã«å¿ èŠãªåºæ¬çãªã¹ãããã詳ãã解説ããŸãã
2.1 å¿ èŠãªããŒã«ãšãœãããŠã§ã¢ã®éžå®
SQLç°å¢æ§ç¯ã®ç¬¬äžæ©ãšããŠãå¿ èŠãªããŒã«ãšãœãããŠã§ã¢ã®éžå®ããããŸããããŒã¿ããŒã¹ã®çš®é¡ãç®çã«å¿ããŠãæé©ãªããŒã«ãéžæããããšãéèŠã§ãã
äžè¬çã«ãMySQLãPostgreSQLãªã©ã®ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ç®¡çã·ã¹ãã (RDBMS)ããã䜿çšãããŸãããããã®RDBMSã¯ãããŒã¿ã®ä¿åãæ€çŽ¢ãæŽæ°ãªã©ã®åºæ¬çãªæäœããµããŒãããŠãããå€ãã®å Žé¢ã§ã®å©çšã«é©ããŠããŸãã
2.2 ã€ã³ã¹ããŒã«ã®æé
éžå®ããããŒã«ããœãããŠã§ã¢ã®ã€ã³ã¹ããŒã«ã¯ãéåžžãå ¬åŒãµã€ãããæäŸãããã€ã³ã¹ããŒã©ã䜿çšããŠè¡ããŸããã€ã³ã¹ããŒã«ã®éã«ã¯ãã·ã¹ãã ã®èŠä»¶ã確èªããé©åãªããŒãžã§ã³ãããŠã³ããŒãããããšãéèŠã§ãã
ã€ã³ã¹ããŒã«ãå®äºããããåæèšå®ãè¡ãå¿ èŠããããŸããããã«ã¯ãããŒã¿ããŒã¹ã®ãŠãŒã¶ãŒåããã¹ã¯ãŒãã®èšå®ãæ¥ç¶æ å ±ã®èšå®ãªã©ãå«ãŸããŸãã
2.3 åæèšå®ãšæ¥ç¶ã®ç¢ºèª
ã€ã³ã¹ããŒã«ãšåæèšå®ãå®äºããããå®éã«ããŒã¿ããŒã¹ã«æ¥ç¶ããŠåäœã確èªããŸããå°çšã®ã¯ã©ã€ã¢ã³ãããŒã«ã䜿çšããŠãããŒã¿ããŒã¹ãµãŒããŒãžã®æ¥ç¶ãè©Šã¿ãŸãã
æ¥ç¶ãæåããããç°¡åãªSQLãå®è¡ããŠããŒã¿ããŒã¹ã®åäœã確èªããŸããäŸãã°ãSELECTæã䜿çšããŠããŒãã«ã®å 容ã衚瀺ããããšãã§ããŸãã
ãããã®ã¹ããããçµãŠãSQLã®ç°å¢æ§ç¯ã¯å®äºã§ããé©åãªç°å¢ãæŽããããšã§ãããŒã¿ããŒã¹ã®æäœãã¹ã ãŒãºã«è¡ããããã«ãªããŸãã
3. åŠç¿çšã®ãµã³ãã«ããŒã¿ã®æºå
SQLã®åŠç¿ãå§ããéãå®éã®ããŒã¿ã䜿çšããŠæäœãè©Šã¿ãããšã¯éåžžã«æå¹ã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãåŠç¿çšã®ãµã³ãã«ããŒã¿ã®éèŠæ§ãšããã®å ¥ææ¹æ³ãã€ã³ããŒãã®æé ã«ã€ããŠè©³ãã解説ããŸãã
3.1 ãµã³ãã«ããŒã¿ã®éèŠæ§
ãµã³ãã«ããŒã¿ã¯ãSQLã®åºæ¬çãªæäœãåŠã¶äžã§ã®å®è·µçãªããŒã«ãšãªããŸããçè«ã ãã§ãªããå®éã®ããŒã¿ã䜿çšããŠæäœãè©Šã¿ãããšã§ãããæ·±ãç解ãæ·±ããããšãã§ããŸãã
3.2 ããããã®ãµã³ãã«ããŒã¿ã®å ¥æå
å€ãã®ããŒã¿ããŒã¹é¢é£ã®ãµã€ããæè²æ©é¢ã§ã¯ãåŠç¿çšã®ãµã³ãã«ããŒã¿ãæäŸããŠããŸãã以äžã¯ãç¹ã«ããããã®ãµã³ãã«ããŒã¿ã®å ¥æå ãããã€ã玹ä»ããŸãã
MySQLå ¬åŒãµã€ãïŒMySQLã®å ¬åŒãµã€ãã§ã¯ããµã³ãã«ããŒã¿ããŒã¹ãšããŠãSakilaããæäŸããŠããŸããããã¯ãæ ç»ã¬ã³ã¿ã«ã·ã§ããã®ããŒã¿ãæš¡ãããã®ã§ãå€ãã®ããŒãã«ãã¬ã³ãŒããå«ãŸããŠããŸãã
MicrosoftïŒMicrosoftã¯ãSQL Serverã®åŠç¿çšãšããŠãAdventureWorksãããŒã¿ããŒã¹ãæäŸããŠããŸããããã¯ã補é æ¥ã販売æ¥ã®ããŒã¿ãæš¡ãããã®ã§ããªã¢ã«ãªããžãã¹ã·ãŒã³ãæ³å®ããããŒã¿ãå«ãŸããŠããŸãã
3.3 ããŒã¿ã®ã€ã³ããŒãæ¹æ³
ãµã³ãã«ããŒã¿ãå ¥æãããã次ã«ããŒã¿ããŒã¹ã«ã€ã³ããŒãããæé ãåŠã³ãŸããäžè¬çã«ããµã³ãã«ããŒã¿ã¯SQLãã¡ã€ã«ã®åœ¢åŒã§æäŸãããããšãå€ãã§ãã
ã€ã³ããŒãã®æé ã¯ã䜿çšããŠããããŒã¿ããŒã¹ç®¡çã·ã¹ãã ãã¯ã©ã€ã¢ã³ãããŒã«ã«ãã£ãŠç°ãªããŸãããåºæ¬çã«ã¯ä»¥äžã®ã¹ãããã«ãªããŸãã
1. SQLãã¡ã€ã«ãéã
2. ããŒã¿ããŒã¹ã«æ¥ç¶ãã
3. SQLãã¡ã€ã«ã®å
容ãå®è¡ãã
ãããã®ã¹ããããçµãŠããµã³ãã«ããŒã¿ãããŒã¿ããŒã¹ã«ã€ã³ããŒããããŸããã€ã³ããŒããå®äºããããå®éã«SQLãå®è¡ããŠããŒã¿ã®å 容ã確èªããããšãã§ããŸãã
4. Windowsã§ã®SQLç°å¢æ§ç¯
Windowsã¯ãäžçäžã§åºã䜿çšãããŠãããªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã®äžã€ã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãWindowsç°å¢ã§ã®SQLã®ç°å¢æ§ç¯ã«ã€ããŠè©³ãã解説ããŸãã
4.1 å¿ èŠãªããŒã«ã®éžå®
Windowsã§SQLã®ç°å¢ãæ§ç¯ããéãæåã«è¡ãã¹ãããšã¯ãé©åãªããŒã¿ããŒã¹ç®¡çã·ã¹ãã (DBMS)ã®éžå®ã§ããWindowsã«ã¯ãå€ãã®DBMSã察å¿ããŠãããããããã®ç¹æ§ãæ©èœã«å¿ããŠéžæããããšãã§ããŸãã
äžè¬çã«ãMySQLãMicrosoft SQL Serverãªã©ãWindowsç°å¢ã§ã®å©çšã«é©ããŠããŸãããããã®DBMSã¯ãå®å®æ§ãããã©ãŒãã³ã¹ããµããŒãäœå¶ãæŽã£ãŠãããããåå¿è ãããããã§ãã·ã§ãã«ãŸã§å¹ åºãå©çšãããŠããŸãã
4.2 ã€ã³ã¹ããŒã«ãšèšå®ã®æé
éžå®ããDBMSã®ã€ã³ã¹ããŒã«ã¯ãå ¬åŒãµã€ãããæäŸãããã€ã³ã¹ããŒã©ã䜿çšããŠè¡ããŸããã€ã³ã¹ããŒã«ã®éã«ã¯ãã·ã¹ãã ã®èŠä»¶ã確èªããé©åãªããŒãžã§ã³ãããŠã³ããŒãããããšãéèŠã§ãã
ã€ã³ã¹ããŒã«ãå®äºããããåæèšå®ãè¡ãå¿ èŠããããŸããããã«ã¯ãããŒã¿ããŒã¹ã®ãŠãŒã¶ãŒåããã¹ã¯ãŒãã®èšå®ãæ¥ç¶æ å ±ã®èšå®ãªã©ãå«ãŸããŸããç¹ã«ãã»ãã¥ãªãã£ã®èŠ³ç¹ããã匷åºãªãã¹ã¯ãŒããèšå®ããããšãããããããŸãã
4.3 ãã©ãã«ã·ã¥ãŒãã£ã³ã°ãšãããããšã©ãŒ
Windowsã§ã®SQLç°å¢æ§ç¯äžã«ã¯ãããŸããŸãªãšã©ãŒãåé¡ãçºçããå¯èœæ§ããããŸããããã§ã¯ããããããšã©ãŒããã®å¯ŸåŠæ¹æ³ã«ã€ããŠè§£èª¬ããŸãã
1. æ¥ç¶ãšã©ãŒïŒããŒã¿ããŒã¹ãžã®æ¥ç¶ãã§ããªãå Žåãæ¥ç¶æ
å ±ããããã¯ãŒã¯ã®èšå®ã確èªããããšãå¿
èŠã§ãã
2. æš©éãšã©ãŒïŒç¹å®ã®æäœãã§ããªãå ŽåããŠãŒã¶ãŒã®æš©éèšå®ã確èªããããšãæ±ããããŸãã
3. ããŒãžã§ã³ã®äºææ§ïŒæ°ããããŒãžã§ã³ã®DBMSã䜿çšããéãå€ãããŒãžã§ã³ã®ããŒã¿ããŒã¹ãšã®äºææ§ã«åé¡ãçºçããããšããããŸãããã®ãããªå ŽåãããŒã¿ããŒã¹ã®ããã¯ã¢ãããã¢ããã°ã¬ãŒãã®æé ãé©åã«è¡ãããšãéèŠã§ãã
ãããã®ãšã©ãŒã¯ãé©åãªç¥èãšæé ãæã£ãŠå¯ŸåŠããããšã§ãã¹ã ãŒãºã«è§£æ±ºããããšãã§ããŸãããã©ãã«ãçºçããéã«ã¯ãå ¬åŒã®ããã¥ã¡ã³ããã³ãã¥ããã£ã®ãµããŒãã掻çšããããšãããããããŸãã
5. Macã§ã®SQLç°å¢æ§ç¯
Macã¯ãã¶ã€ããŒãéçºè ã«äººæ°ã®é«ããªãã¬ãŒãã£ã³ã°ã·ã¹ãã ã§ãããã®ã»ã¯ã·ã§ã³ã§ã¯ãMacäžã§ã®SQLç°å¢æ§ç¯ã«ã€ããŠã詳ãã解説ããŸãã
5.1 å¿ èŠãªããŒã«ã®éžå®
Macã§SQLã®ç°å¢ãæŽããéãæåã«è¡ãã¹ãã¯ãé©åãªããŒã¿ããŒã¹ç®¡çã·ã¹ãã (DBMS)ã®éžå®ã§ããMacã«ã¯ãå€ãã®DBMSã察å¿ããŠãããããããã®ç¹æ§ãæ©èœã«å¿ããŠéžæããããšãã§ããŸãã
äžè¬çã«ãMySQLãPostgreSQLãªã©ãMacç°å¢ã§ã®å©çšã«é©ããŠããŸãããããã®DBMSã¯ãå®å®æ§ãããã©ãŒãã³ã¹ããµããŒãäœå¶ãæŽã£ãŠãããããåå¿è ãããããã§ãã·ã§ãã«ãŸã§å¹ åºãå©çšãããŠããŸãã
5.2 ã€ã³ã¹ããŒã«ãšèšå®ã®æé
éžå®ããDBMSã®ã€ã³ã¹ããŒã«ã¯ãå ¬åŒãµã€ããããã±ãŒãžãããŒãžã£ãŒã䜿çšããŠè¡ããŸããMacã§ã¯ãHomebrewãšããããã±ãŒãžãããŒãžã£ãŒã人æ°ã§ãããã䜿çšããŠç°¡åã«DBMSãã€ã³ã¹ããŒã«ããããšãã§ããŸãã
ã€ã³ã¹ããŒã«ãå®äºããããåæèšå®ãè¡ãå¿ èŠããããŸããããã«ã¯ãããŒã¿ããŒã¹ã®ãŠãŒã¶ãŒåããã¹ã¯ãŒãã®èšå®ãæ¥ç¶æ å ±ã®èšå®ãªã©ãå«ãŸããŸããç¹ã«ãã»ãã¥ãªãã£ã®èŠ³ç¹ããã匷åºãªãã¹ã¯ãŒããèšå®ããããšãããããããŸãã
5.3 ãã©ãã«ã·ã¥ãŒãã£ã³ã°ãšãããããšã©ãŒ
Macã§ã®SQLç°å¢æ§ç¯äžã«ã¯ãããŸããŸãªãšã©ãŒãåé¡ãçºçããå¯èœæ§ããããŸããããã§ã¯ããããããšã©ãŒããã®å¯ŸåŠæ¹æ³ã«ã€ããŠè§£èª¬ããŸãã
1. æ¥ç¶ãšã©ãŒïŒããŒã¿ããŒã¹ãžã®æ¥ç¶ãã§ããªãå Žåãæ¥ç¶æ
å ±ããããã¯ãŒã¯ã®èšå®ã確èªããããšãå¿
èŠã§ãã
2. æš©éãšã©ãŒïŒç¹å®ã®æäœãã§ããªãå ŽåããŠãŒã¶ãŒã®æš©éèšå®ã確èªããããšãæ±ããããŸãã
3. ããŒãžã§ã³ã®äºææ§ïŒæ°ããããŒãžã§ã³ã®DBMSã䜿çšããéãå€ãããŒãžã§ã³ã®ããŒã¿ããŒã¹ãšã®äºææ§ã«åé¡ãçºçããããšããããŸãããã®ãããªå ŽåãããŒã¿ããŒã¹ã®ããã¯ã¢ãããã¢ããã°ã¬ãŒãã®æé ãé©åã«è¡ãããšãéèŠã§ãã
ãããã®ãšã©ãŒã¯ãé©åãªç¥èãšæé ãæã£ãŠå¯ŸåŠããããšã§ãã¹ã ãŒãºã«è§£æ±ºããããšãã§ããŸãããã©ãã«ãçºçããéã«ã¯ãå ¬åŒã®ããã¥ã¡ã³ããã³ãã¥ããã£ã®ãµããŒãã掻çšããããšãããããããŸãã
6. SQLã®åºæ¬çãªæäœ
SQLã¯ããŒã¿ããŒã¹æäœã®ããã®èšèªã§ãããããŒã¿ã®è¿œå ãæ€çŽ¢ãæŽæ°ãåé€ãªã©ãå€å²ã«ãããæäœãè¡ãããšãã§ããŸãããã®ã»ã¯ã·ã§ã³ã§ã¯ãSQLã®åºæ¬çãªæäœã«ã€ããŠã詳ãã解説ããŸãã
6.1 ããŒãã«ã®äœæãšããŒã¿ã®è¿œå
ããŒã¿ããŒã¹ã®äžæ žããªãã®ããããŒãã«ãã§ããããŒãã«ã¯ãè¡ãšåãããªãè¡šã®ãããªæ§é ãæã¡ãããŒã¿ãæŽçããŠä¿åããããã®å ŽæãšãªããŸãã
ããŒãã«ã®äœæã¯ãCREATE TABLEæã䜿çšããŠè¡ããŸããäŸãã°ãåŠçã®æ å ±ãä¿åããããŒãã«ãäœæããå Žåã以äžã®ãããªSQLæãå®è¡ããŸãã
CREATE TABLE students ( id INT PRIMARY KEY, name VARCHAR(50), age INT, major VARCHAR(50) );
ããŒãã«ãäœæãããããINSERT INTOæã䜿çšããŠããŒã¿ãè¿œå ããããšãã§ããŸãã
INSERT INTO students (id, name, age, major) VALUES (1, 'Taro', 20, 'Computer Science');
6.2 ããŒã¿ã®æ€çŽ¢ãšæŽæ°
ããŒã¿ããŒã¹ã«ä¿åãããŠããããŒã¿ãæ€çŽ¢ããã«ã¯ãSELECTæã䜿çšããŸããäŸãã°ã20æ³ä»¥äžã®åŠçã®æ å ±ãæ€çŽ¢ããå Žåã以äžã®ãããªSQLæãå®è¡ããŸãã
SELECT * FROM students WHERE age >= 20;
ä¿åãããŠããããŒã¿ãæŽæ°ããå Žåã¯ãUPDATEæã䜿çšããŸããäŸãã°ãTaroã®å°æ»ãMathematicsã«å€æŽããå Žåã以äžã®ãããªSQLæãå®è¡ããŸãã
UPDATE students SET major = 'Mathematics' WHERE name = 'Taro';
6.3 ããŒã¿ã®åé€ãšããã¯ã¢ãã
äžèŠã«ãªã£ãããŒã¿ãåé€ããå Žåã¯ãDELETEæã䜿çšããŸããäŸãã°ãTaroã®ããŒã¿ãåé€ããå Žåã以äžã®ãããªSQLæãå®è¡ããŸãã
DELETE FROM students WHERE name = 'Taro';
ããŒã¿ããŒã¹ã®ããŒã¿ã¯éåžžã«éèŠãªãããå®æçãªããã¯ã¢ãããæšå¥šãããŸããå€ãã®DBMSã«ã¯ãããŒã¿ããŒã¹ã®ããã¯ã¢ãããåãããã®ããŒã«ãæ©èœãæäŸãããŠããŸãããããå©çšããŠãããŒã¿ã®å®å šã確ä¿ããããšãã§ããŸãã
7. ãŸãšããšæ¬¡ã®ã¹ããã
ãã®èšäºãéããŠãSQLç°å¢æ§ç¯ã®åºæ¬ããå ·äœçãªæé ããããŠåºæ¬çãªæäœãŸã§ãåŠã³ãŸãããããŒã¿ããŒã¹ã¯æ å ±ç€ŸäŒã«ãããŠäžå¿çãªåœ¹å²ãæãããŠããããã®æäœãåŠã¶ããšã¯éåžžã«äŸ¡å€ããããŸãã
7.1 SQLç°å¢æ§ç¯ã®ãã€ã³ãã®å確èª
ãŸããSQLç°å¢æ§ç¯ã®éã®ãã€ã³ããå確èªããŸããããé©åãªDBMSã®éžå®ãã€ã³ã¹ããŒã«æé ã®ç¢ºèªããããŠåæèšå®ã®éèŠæ§ãç解ããããšããã¹ã ãŒãºãªç°å¢æ§ç¯ã®éµãšãªããŸãããŸãããã©ãã«ã·ã¥ãŒãã£ã³ã°ã®åºæ¬çãªç¥èãæã£ãŠããããšã§ãåé¡ãçºçããéã®å¯Ÿå¿ãè¿ éã«è¡ããŸãã
7.2 ãããªãåŠç¿ãªãœãŒã¹ã®çŽ¹ä»
ãã®èšäºã§åŠãã å 容ã¯ãSQLã®å ¥éãšããŠã®åºæ¬çãªéšåã«çãŸããŸããããã«æ·±ãåŠã³ããæ¹ã®ããã«ã以äžã®åŠç¿ãªãœãŒã¹ã玹ä»ããŸãã
1. å
¬åŒããã¥ã¡ã³ãïŒåDBMSã®å
¬åŒãµã€ãã«ã¯ã詳现ãªããã¥ã¡ã³ãããã¥ãŒããªã¢ã«ãæäŸãããŠããŸãããããã®æ
å ±ã¯ãæãä¿¡é Œæ§ãé«ããææ°ã®æ
å ±ãåŸãããšãã§ããŸãã
2. ãªã³ã©ã€ã³ã³ãŒã¹ïŒUdemyãCourseraãªã©ã®ãªã³ã©ã€ã³åŠç¿ãã©ãããã©ãŒã ã«ã¯ãSQLã«é¢ããå€ãã®ã³ãŒã¹ãæäŸãããŠããŸããåå¿è
ããäžçŽè
ãŸã§ãæ§ã
ãªã¬ãã«ã®ã³ãŒã¹ãçšæãããŠãããããèªåã®åŠç¿ç®çã«åãããŠéžã¶ããšãã§ããŸãã
3. æžç±ïŒãSQLå®è·µå
¥éãããããŒã¿ããŒã¹ã·ã¹ãã ã®åºç€ããªã©ãå€ãã®åªããæžç±ãåºçãããŠããŸããå®éã«æãåãããªããåŠã¶ããšãã§ããã®ã§ãæ·±ãç解ãåŸãããã«ã¯æžç±ã®å©çšãããããã§ãã
æåŸã«ãSQLã®åŠç¿ã¯ç¶ç¶çãªå®è·µãå¿ èŠã§ããå®éã«æãåãããå€ãã®åé¡ã解決ããããšã§ãã¹ãã«ã磚ããŠããããšãã§ããŸãããã®èšäºããããªãã®åŠç¿ã®ç¬¬äžæ©ãšãªãããšãé¡ã£ãŠããŸãã