I'm so late to your videos but love them man. You've done a really good job with your energy and and posing questions during walkthrough. SQL can be confusing (im a SQL/Tableau dev).
Fantastic, thanks so much Trevor. I'm just taking a break as we have a new addition to the family but will be back at the beginning of next year with more content.
Help please Album Discount!! How do you solve this question please Sir Write a single SQL statement to list albums with four columns: the title of the album, the total number of track in that album, the price of the album, and the discounted price of the album. All albums priced above forty dollars wpuld be given a ten percent discount.All other albums would be given a discounted price N/A in the output. Exclude albums that are priced lower than thirty dollars from the output. Rename the column headins appropritely and sort the output by price decendingly.
Hi Moepi, Did you manage to solve the problem or would you like me to do a video on this? You would need to use a CASE statement for this, however there would be an issue with the data type of the discounted column, if you want to show price then normally you would use DECIMAL data type but this would not accept N/A in the result, so if you needed N/A you would have to use a string data type. Please let me know if you need any assistance.
@@BeardedDevData I'd write it ko-a-less, but not so far from your spelling. So I'm wondering why you pronounce it kow-uh-LEASE. I've never heard it pronounced that way. Is it a regional thing? How would you pronounce it outside of the SQL environment? Not saying its wrong, just interested!
@@EASYTIGER10 I should pronounce it how you have stated but I've just got in to the habit of pronouncing the end lease for some reason, just one of those things, it's not really a word I use everyday outside of SQL so hard for me to comment
Thank you so much for your great content! Your channel is very underrated!
Thanks for the positive feedback.
Thank you very much for priceless explanation and effort you spend for us. Thanks, sir!
Thanks for another great video. Tackling the two clauses together with consecutive examples was very helpful!
Really nice tutorial!! I like your voice.
I'm so late to your videos but love them man. You've done a really good job with your energy and and posing questions during walkthrough. SQL can be confusing (im a SQL/Tableau dev).
Fantastic, thanks so much Trevor. I'm just taking a break as we have a new addition to the family but will be back at the beginning of next year with more content.
Explained clearly. Great video
Great explanation, very helpful
Another great video. Thanks
thanks for the great video, I learned a lot
great video thank you very much
Excellent please upload videos on Dead locks, Blocking, Table partion
Thanks for the recommendations
Help please
Album Discount!!
How do you solve this question please Sir
Write a single SQL statement to list albums with four columns: the title of the album, the total number of track in that album, the price of the album, and the discounted price of the album. All albums priced above forty dollars wpuld be given a ten percent discount.All other albums would be given a discounted price N/A in the output.
Exclude albums that are priced lower than thirty dollars from the output. Rename the column headins appropritely and sort the output by price decendingly.
Can you show me your query so far?
Hi Moepi,
Did you manage to solve the problem or would you like me to do a video on this?
You would need to use a CASE statement for this, however there would be an issue with the data type of the discounted column, if you want to show price then normally you would use DECIMAL data type but this would not accept N/A in the result, so if you needed N/A you would have to use a string data type.
Please let me know if you need any assistance.
coa les. It's pronounced like co less... ARRRRGGGG!!!! /ˌkōəˈles/
It’s pronounced kow-uh-les in both British and American, don’t worry though if you’ve been pronouncing it incorrectly, that’s not what’s important.
@@BeardedDevData I'd write it ko-a-less, but not so far from your spelling. So I'm wondering why you pronounce it kow-uh-LEASE. I've never heard it pronounced that way. Is it a regional thing? How would you pronounce it outside of the SQL environment? Not saying its wrong, just interested!
@@EASYTIGER10 I should pronounce it how you have stated but I've just got in to the habit of pronouncing the end lease for some reason, just one of those things, it's not really a word I use everyday outside of SQL so hard for me to comment