USYD - INFO 2120 - SQL Challenge #1 Solution

1-  select * from country

2-  select count(*) from film 

3-  select * from film where fil_id=271

4-  select release_year from film where title='FLASH WARS' 

5-  select first_name, last_name from actor where nationality='AU'

6-  insert into actor (actor_id,first_name, last_name,nationality) 
                             values (4711,'Arnold','Schwarzenegger','AT')

7-

CREATE TABLE Person (
    license INTEGER PRIMARY KEY,
  name VARCHAR(50) NOT NULL
    );

CREATE TABLE CAR (
    model VARCHAR(30),
  owner INTEGER REFERENCES Person (license),
  regno CHAR(6) PRIMARY KEY
    );

8- UPDATE film SET rental_rate=2.52 where title='ANGELS LIFE';  

9-  create table Studio (
  studio_id INTEGER PRIMARY KEY,
  name VARCHAR(50) NOT NULL,
  address VARCHAR(100) ,  
  country CHAR(2) NOT NULL REFERENCES Country (short_code)
); 

New Idea Sharing Website

I just saw a cool on my friend, new website, Xagrox.com, which is currently under some tests until becomes available for public. it lacks good design though. and needs some innovation. I mean it should bring a new innovative idea. till then adiós