Pages: 1 [2] 3 4 ... 6
  Print  
Author Topic: มาช่วยกันเฉลยแบบฝึกหัดวิชา Database ดีกว่า  (Read 24836 times)
0 Members and 1 Guest are viewing this topic.
คนมันสวยช่วยไม่ได้
CE45
*****

คะแนนจิตพิสัย 0
Offline Offline

Posts: 237



« Reply #20 on: 13 February, 2009, 02:19:01 »

ทีระรัดทำเค้าเครียด กรี้ดดดดดดดด 007
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #21 on: 20 February, 2009, 13:33:22 »

18.
Code:
SELECT COUNT(DISTINCT CANDIDATE) FROM ELECTION WHERE WINNER_LOSER_INDIC = 'L'


* 18.JPG (20.32 KB, 652x331 - viewed 235 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #22 on: 20 February, 2009, 13:35:17 »

19.
Code:
SELECT COUNT(*) FROM STATE WHERE ADMIN_ENTERED IS NULL


* 19.JPG (19.04 KB, 652x331 - viewed 254 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #23 on: 20 February, 2009, 13:38:43 »

20.
Code:
SELECT AVG(DEATH_AGE) FROM PRESIDENT WHERE PARTY='Republican' AND BIRTH_YR>1850 AND DEATH_AGE IS NOT NULL


* 20.JPG (19.58 KB, 652x331 - viewed 234 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #24 on: 20 February, 2009, 13:41:01 »

21.
Code:
SELECT COUNT(*) FROM PRES_MARRIAGE


* 21.JPG (19.03 KB, 652x331 - viewed 249 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #25 on: 20 February, 2009, 13:45:44 »

22.
Code:
SELECT COUNT(*) FROM PRESIDENT WHERE BIRTH_YR+DEATH_AGE >=1985 OR DEATH_AGE IS NULL


* 22.JPG (19.09 KB, 652x331 - viewed 253 times.)
« Last Edit: 23 February, 2009, 20:24:42 by Tee » Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #26 on: 20 February, 2009, 13:50:06 »

23.
Code:
SELECT COUNT(DISTINCT PRES_NAME),MIN(YEAR_INAUGURATED) FROM ADMINISTRATION


* 23.JPG (22.45 KB, 652x331 - viewed 234 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #27 on: 20 February, 2009, 13:54:53 »

24.อ่านแล้วงง
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #28 on: 20 February, 2009, 13:59:58 »

25.
Code:
SELECT SPOUSE_NAME,SP_AGE FROM PRES_MARRIAGE WHERE SP_AGE = (SELECT MIN(SP_AGE) FROM PRES_MARRIAGE)


* 25.JPG (20.35 KB, 652x331 - viewed 244 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #29 on: 20 February, 2009, 14:02:29 »

26.
Code:
SELECT SUM(NR_CHILDREN) FROM PRES_MARRIAGE WHERE SP_AGE < 20


* 26.JPG (19.64 KB, 652x331 - viewed 240 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #30 on: 20 February, 2009, 14:04:48 »

27.
Code:
SELECT AVG(PR_AGE)-AVG(SP_AGE) FROM  PRES_MARRIAGE
SELECT 1.0*AVG(PR_AGE)-AVG(SP_AGE) FROM  PRES_MARRIAGE


* 27.JPG (20.35 KB, 652x331 - viewed 243 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #31 on: 20 February, 2009, 14:06:57 »

28.
Code:
SELECT COUNT(*) FROM PRES_MARRIAGE WHERE PR_AGE-SP_AGE >=2


* 28.JPG (19.02 KB, 652x331 - viewed 229 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #32 on: 20 February, 2009, 14:10:39 »

29.
Code:
SELECT 1.0*PR_AGE/SP_AGE,* FROM PRES_MARRIAGE


* 29.JPG (33.97 KB, 652x331 - viewed 252 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #33 on: 20 February, 2009, 14:15:00 »

30.
Code:
SELECT * FROM PRES_MARRIAGE WHERE PR_AGE-SP_AGE <=2 AND PR_AGE-SP_AGE >= 0


* 30.JPG (38.61 KB, 652x331 - viewed 238 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #34 on: 20 February, 2009, 14:18:24 »

31.อ่านแล้วงง
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #35 on: 20 February, 2009, 14:23:50 »

32.
Code:
SELECT ELECTION_YEAR , COUNT(*) FROM ELECTION WHERE ELECTION_YEAR>1900 GROUP BY ELECTION_YEAR ORDER BY 1


* 32.JPG (23.62 KB, 652x331 - viewed 246 times.)
Report to moderator   Logged
Tee
Administrator
*****

คะแนนจิตพิสัย 2
Offline Offline

Gender: Male
Posts: 2516


terarat@gmail.com
WWW Email
« Reply #36 on: 20 February, 2009, 14:27:38 »

33.ทำไมมันเหมือนกับ 32 เลย ต่างกันที่ตัวเลขอย่างเดียว
Code:
SELECT ELECTION_YEAR , COUNT(*) FROM ELECTION WHERE ELECTION_YEAR>1899 GROUP BY ELECTION_YEAR ORDER BY 1 ASC


* 33.JPG (23.64 KB, 652x331 - viewed 227 times.)
Report to moderator   Logged
PinCaT
น้องใหม่พูดคุย
*

คะแนนจิตพิสัย 0
Offline Offline

Posts: 21


Email
« Reply #37 on: 20 February, 2009, 15:12:44 »

โปรแกรมนี้ใครรับบน Vista ได้มั่ง บอกหน่อย ต้องทำไงอ่ะ
Report to moderator   Logged
Ge
น้องใหม่พูดคุย
*

คะแนนจิตพิสัย 0
Offline Offline

Posts: 16



« Reply #38 on: 21 February, 2009, 17:31:21 »

ลงมิได้เหมือนกัน  กะ vista อ่ะ ตูน
Report to moderator   Logged
PinCaT
น้องใหม่พูดคุย
*

คะแนนจิตพิสัย 0
Offline Offline

Posts: 21


Email
« Reply #39 on: 21 February, 2009, 18:42:45 »

เราเข้าได้แร้วๆ ทำเหมือน XP เรย
Report to moderator   Logged
Pages: 1 [2] 3 4 ... 6
  Print  
 
Jump to: