Database Solution - Activity #5 - Weekly Report | Tagalog Tutorial

[tonyvansantos]

I am Computer Engineer pero sa semiconductor ako na line.. Nakaka inspire ulit mag program 😊 Thank you Sir Frace 😊

[skysea]

Wow..grabe.. basic na basic lang kay lodi...😄😁😄.. more pa lods..

[TanjiroKamado-uu]

Hi Idolc, gaganda ng mga content nio po. :) Hopefully mau tutorial po kayo kung paano mag consume ng web api using mvc with image upload sa blob and auth and auth. :) Keep it up Idol. 🙌

[aldrinida]

Idol pde ba mag pabulig haem nga ma recover tak Gmail

[heypaulleey]

Idol, ano pong gamit na database server sa mga stand alone application po sa desktop, like mga simple program po? Kagaya ng attendance system.

[rhoeldainpascua]

sir ask lang meron po ba payment gateway for gcash? for website

[noban_]

sir, gagawa kasi ako ng java system with gui, solo lng ako pero dapat by group to any advice kung anong project gawin ko ung kaya ko (beginner knowledge)

[migojertech]

Awesome kung mag pursue ako programing dito nako manuod

[ken]

Gawa ka din idol ng tutorial ng python. Hehe godbless

[Jiro_Laurenz]

Kuya Frace, tanong ko lang po sana kung gusto kong ipasa iyung gawa kong WinForms App sa ibang computer at naka-integrate po ito sa microsoft sql server. Iyung pagpapasahan ko po ba ng app eh kailangan pa pong downloadan ng microsoft sql server? Kung hindi na po, paano po kaya? Sana masagot ninyo po, salamat!

[ernestogonaboiii]

Sir my video poba kayo pano gumawa ng sendgrid account?

[neutronwar]

May pagasa pabang makuha sa mga programming jobs kahit no experience at age of 30 ?😞

[charmainetongayan]

Yung akin naman sir pang kanto style pero same result haha.
SELECT Week_day, Total, Total - LAG(Total) OVER (ORDER BY Week_day) AS Gain, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday
FROM
(
SELECT DATEPART(WEEK, t.ProcessedDate) AS Week_day, SUM(t.Amount) AS Total,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 1 THEN t.Amount ELSE null END) AS Sunday,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 2 THEN t.Amount ELSE null END) AS Monday,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 3 THEN t.Amount ELSE null END) AS Tuesday,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 4 THEN t.Amount ELSE null END) AS Wednesday,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 5 THEN t.Amount ELSE null END) AS Thursday,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 6 THEN t.Amount ELSE null END) AS Friday,
SUM(CASE WHEN DATEPART(WEEKDAY, t.ProcessedDate) = 7 THEN t.Amount ELSE null END) AS Saturday
FROM Products p
JOIN Transactions t
ON p.id = t.Product_id
GROUP BY DATEPART(WEEK, t.ProcessedDate)
)a1

[alexcute]

Sana Sir madiscuss ninyo Ang fakebookings at paano ito nangyayari at mkpgsuggest Kyo Ng solutions pra masawata ito.. thank you.

[rgbp]

si frace c# programmer po kayo? balak ko kasi gaya ng work. nyu naka wfh, php. programmer po kasi ako, pero na stop ako mag program since 2020, 7yrs php dev ako sa isang school, nung nag resign ako sa work, balak ko bumalik at mag self study pero pinag iispan ko anung language..

[chromozone]

Master baka may tutorial ka jan ng uploading ng Million data row from excel to sql server.

[danielgiducosjr]

Sir, master pabasbas po incoming 1st year BSIT, laking tulong po nang mga vd mo para manlaki mata ko sa pasukan

[adoraguila]

Pwede po maka connect sa linkedin master frace?

[ViperStrike-pc]

Paano po maka access sa github nio. May account na po ako