Any Sql Pros Out There Who Want To Make A Quick $50

[MAN UTD]

please pm me

[rapchik]

But How????[img]http://lh6.ggpht.com/-E2il_ZAGpuA/TnO1GV8BpzI/AAAAAAAAEKI/KfygvpozWUs/Kajal-2.gif[/img]

[MAN UTD]

got some queries to be written. 14 basic n simple queries. they are a part of assignment

[MAN UTD]

arent there any1 good at sql?
They are so basic queries, and I am sure any1 with a decent knowledge of sql can do it in less than an hour.

[charygaru]

stewiegriffin might help you pm him

[CORLEONE]

sample ga okati veye ikkada

[MAN UTD]

[quote name='charygaru' timestamp='1327539470' post='1301349799']
stewiegriffin might help you pm him
[/quote]

oh thanks for the info.
sadly he is offline, and the guy who needs these queries got few hours left to submit

[MAN UTD]

helpp

[MAN UTD]

[quote name='CORLEONE' timestamp='1327539668' post='1301349816']
sample ga okati veye ikkada
[/quote]



Q1 Find borrowers (by name) who have ever borrowed a book written by Phillip Pullman.

Q2 Find borrowers (by name) who have currently on loan a book written by Phillip Pullman

Q3 Give the ISBN and title of each book and the number of copies currently on loan listing most popular first.

Q4 Display the names of borrowers who have never borrowed books published by the publisher Mammoth.

Q5 Give the titles of books which have the same value as ‘Northern Lights’. Do not include Northern Lights in your output.

[nag]

[quote name='MAN UTD' timestamp='1327541504' post='1301349901']



Q1 Find borrowers (by name) who have ever borrowed a book written by Phillip Pullman.

Q2 Find borrowers (by name) who have currently on loan a book written by Phillip Pullman

Q3 Give the ISBN and title of each book and the number of copies currently on loan listing most popular first.

Q4 Display the names of borrowers who have never borrowed books published by the publisher Mammoth.

Q5 Give the titles of books which have the same value as ‘Northern Lights’. Do not include Northern Lights in your output.
[/quote]


Neeku already PM petta..help chesta ani no reply from you...

[MAN UTD]

[quote name='nag' timestamp='1327542567' post='1301349944']


Neeku already PM petta..help chesta ani no reply from you...
[/quote]

i did replied with all the details. can u pls check again?

[ramu]

select *
from Table_name
where book_name='Philip Pullman'


select ISBN,Title,count( copies) cnt
from table_name
group by ISBN,Title
order by cnt desc;

[MAN UTD]

[quote name='RockStarZ' timestamp='1327542782' post='1301349951']

[/quote]

thanks for the replies rockstar

[ramu]

[quote name='MAN UTD' timestamp='1327543173' post='1301349972']
thanks for the replies rockstar
[/quote]
details clarity levu mama vere rayataniki.... by the way u r welcome

[MAN UTD]

[quote name='RockStarZ' timestamp='1327543239' post='1301349976']
details clarity levu mama vere rayataniki.... by the way u r welcome
[/quote]

tables and data varaku nenu create chesi, insert chesi petta.
kani queries rase anta knowledge ledu. so looking out for some help.
thanks again