help needed on mysql queries. (submission tomorrow )

**quantum physics** · Jan 23, 2011 06:37

Hi Folks.
I really need some desperate help on a few Mysql queries urgently.
can anyone please help me around here?
I'd really really appreciate It.

here are the questions!
http://i.imgur.com/ABy0f.jpg
http://i.imgur.com/XIGLk.jpg

please guys, this means the world to me.

All hail Tim Berners Lee!!

**r937** · Jan 23, 2011 07:01

here are the answers:
http://i.imgur.com/hJJY0.jpg

**guido2004** · Jan 23, 2011 07:10

Originally Posted by r937

here are the answers:
http://i.imgur.com/hJJY0.jpg

**quantum physics** · Jan 23, 2011 09:11

Originally Posted by r937

here are the answers:
http://i.imgur.com/hJJY0.jpg

I know I'm in a soup here, I was gonna get It done but was pinned by a really bad viral infection, can barely even watch the screen.
I know I should have gotten It done earlier but It seems my infection has gotten the better of me at the moment.
please guys, a little help will go a long way in saving my backside here.
this Is really important.

**r937** · Jan 23, 2011 09:33

we are here to help you

let's start with question 1 -- what is your best attempt at the SQL?

**quantum physics** · Jan 23, 2011 09:48

Originally Posted by r937

we are here to help you

let's start with question 1 -- what is your best attempt at the SQL?

we'll, I can scrape up the project some how,we'll mostly writing wrong queries. and I would actually go for It and do It myself but this project really needs to be top notch, I would have tried to get It done myself but the time factor Is really against me.

**furicane** · Jan 23, 2011 11:05

That implies you really should start your homework sooner, not at the last minute

**oddz** · Jan 23, 2011 13:01

Code SQL:

CREATE TABLE EMP_DETAILS (
	 employee_no VARCHAR(17) NOT NULL
	,first_name VARCHAR(17) NOT NULL
	,surname VARCHAR(17) NULL
	,last_name VARCHAR(17) NOT NULL
	,birth DATE NOT NULL
	,gender ENUM('male','female') NOT NULL
	,department VARCHAR(128) NOT NULL
	,designation VARCHAR(128) NOT NULL
	,salary MEDIUMINT NOT NULL
	,PRIMARY KEY(employee_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;