nrogap

SELECT 
student_id,
first_name,
last_name,
CONCAT(first_name,' ',last_name) AS full_name,
FROM person p
INNER JOIN class_room cr
ON p.student_id = cr.student_id
WHERE
cr.class_room_name = '6/1'

nrogap

SELECT 
student_id,
first_name,
last_name,
CONCAT(first_name,' ',last_name) AS full_name,
FROM person p
INNER JOIN class_room cr
ON p.student_id = cr.student_id
WHERE
cr.class_room_name = '6/1'

nrogap

SELECT * FROM person
WHERE name = 'Pagorn' 
AND sname = 'Petchara'

nrogap

#import <Foundation/Foundation.h>

int main ()
{
        NSAutoreleasePool *pool = [[NSAutoreleasePool alloc] init];
        NSLog (@"Hello World Objective-C");
        [pool drain];
        return 0;
}