Welcome to Pinoy Tech Forum

[mage1968]

Hello ka-netizion, bka meron ditong master sa SQL using pgadmin4(postgreSQL)

pahelp sana ako if tama ba itong syntax sa pgadmin4 query, ng.aaral ksi ako ng SQL at ito assignment namin

1st query picture ->
heto yung syntax nya ->

SELECT * FROM film
WHERE title LIKE 'S%' OR title LIKE 'T%' AND replacement_cost BETWEEN 15.99 AND 20.99

yung sa baba "Data Output" section yan yung results nya.


2nd query picture ->
syntax query ->

SELECT title,length FROM film
WHERE title LIKE 'T%' OR title LIKE 'S%' AND replacement_cost BETWEEN 15.99 AND 20.99
ORDER by length DESC
LIMIT 20

yung sa baba "Data Output" section yan yung results nya.
---------------------------------------------------------------------------------------------------------------
heto yung questions sa assignment namin


i highly appreciated kung sinu man makakapagshare ng correct answers sa syntax query ko.
ng.post na ako nito sa mga fb groups na programming kso nabash lng ako ng kapwa pinoy imbes tulong lng sana gusto ko makuha sa kasagutan ko sa SQL query.

Thank you Admin!

 

[echoarar]

Try ko ko magbigay ng script sayo.

 

[echoarar]

SELECT title
,length
FROM film
WHERE (title LIKE 'T%' OR title LIKE 'S%')
AND (replacement_cost BETWEEN 15.99 AND 20.99)
AND RATING IN ('PG','PG-13','G')
ORDER by title ASC

 

[echoarar]

Try mo yan

 

[mage1968]

okay po, itry ko po itong code

 

[mage1968]

SELECT title
,length
FROM film
WHERE (title LIKE 'T%' OR title LIKE 'S%')
AND (replacement_cost BETWEEN 15.99 AND 20.99)
AND RATING IN ('PG','PG-13','G')
ORDER by title ASC

1st.____________2nd..


inedit ko muna itong 1st script, heto query result master, ayaw lumabas ng table ni ''replacement_cost" hehe

pero dito sa SELECT * FROM film, makikita lahat ng table

 

[echoarar]

Sige check koto mamaya on duty pa ako

 

[echoarar]

SELECT title
,length
,replacement_cost
FROM film
WHERE (title LIKE 'T%' OR title LIKE 'S%')
AND (replacement_cost BETWEEN 15.99 AND 20.99)
AND RATING IN ('PG','PG-13','G')
ORDER by title ASC

 

[mage1968]

Sige check koto mamaya on duty pa ako

thank you master sa pg.sagot sa thread ko. update kita about dun sa bagong script hehe

 

[mage1968]

Sige check koto mamaya on duty pa ako

master, tama ba itong explanation query ko sa ganitong question?




sa question A. may sagot na ako na query.


sa question B. ito results ng query ko , gumamit ako ng inner,union pero ayaw lumabas ni film table? ang results is customer_id at film lang ang results?

thank you sa response...

 

[echoarar]

wag mo lagyan ng ' '