SQL දන්න කෙනෙක් HELP ME plzz !!

[Dilshankgc]

SQL දන්න කෙනෙක් HELP ME plzz !!

දන්න කෙනෙක් මට මේ ටිකට Answers දෙන්න පුලුවම්ද​???

සේරටම නැතත් පුලුවම් ටිකකට හරි

 

[CoolBro]

machan uba sliit eke paper ekakata neda naswer illane meka 2nd year dbms neda try karannam help karann tikak wela yawi

 

[Dilshankgc]

machan uba sliit eke paper ekakata neda naswer illane meka 2nd year dbms neda try karannam help karann tikak wela yawi

ow ban.. Thanks machan puluwam nam loku udawwak

 

[CoolBro]

Select * from Student.s
where s.gender ='male' And s.age<18
---------------------------------------------------------(Option)
SELECT * FROM Customers
WHERE gender='male'
AND (age age<18);

2nd one

SELECT AVG(Numberofcredits)
FROM Course

3rd one...

SELECT subname
FROM Subject
WHERE subid=(SELECT CourseNumber FROM Course_Offers_subject);

machan uba temp tabale ekak gahala value tikak dala check akrahn W3school use karahn

 

[MihiCherub]

a.
SELECT Studentname FROM student WHERE gender = 'male' AND age < 18;

b.
SELECT avg(NumberofCredits) from Course

ඉතුරුව වෙන කවුරුහරි දායි. නැත්නම් හෙට කියන්නම්.

 

[වල්පාල]

Select Studentname
from student
where gender= 'male' and age<18

select AVG(numberofCredits)
from course

select a.coursenumber, b.subjects
from course_offers_subject a , subject b
where a.subid= b.subid

select count(sid)
from student s, course c
where s.coursennumber = c.courcenumber


select s.studentname , s.sid
from student s, course_offers_subject c
where s.coursenumber=c.coursenumber
group by s.sid
having count(c.subid)>5

select a.studentname
from student a , studet b
where a.sid=b.sid AND b.studentName='ann johnathon' and a.age>b.age

 

[mzonerz]

c.

Select CourseNumber, subname from as c inner join
Course_offers-subject as cs
on c.CourseNumber=cs.CourseNumber inner join
Subject as s
s.subid=cs.subid;

podk blpan query eka liyla studio eke,guess krla liwwe methana
ide eka ntwa wde nikan agata enet ne bn magula addict wela tynne ide walata

 

[D#rox]

Select * from Student.s
where s.gender ='male' And s.age<18
---------------------------------------------------------(Option)
SELECT * FROM Customers
WHERE gender='male'
AND (age age<18);

2nd one

SELECT AVG(Numberofcredits)
FROM Course

3rd one...

SELECT subname
FROM Subject
WHERE subid=(SELECT CourseNumber FROM Course_Offers_subject);

machan uba temp tabale ekak gahala value tikak dala check akrahn W3school use karahn

meka hari machan
mata anidda DB 1 repeat eka ban
​

 

[Dilshankgc]

Thanks machanla