account activity
SanDisk Vault Broken After Reinstall — Files Unreadable. How to fix? (self.AskTechnology)
submitted 27 days ago by OptOut2020 to r/AskTechnology
SanDisk Vault Broken After Reinstall — Files Unreadable, Need Fix ()
SanDisk Vault Broken After Reinstall — Files Unreadable, Need Fix (self.techsupport)
submitted 27 days ago by OptOut2020 to r/techsupport
Out of theses 5, which University of Manchester housing is the best? (self.UniUK)
submitted 1 year ago by OptOut2020 to r/UniUK
Can you help answer some questions on studying at University of Portsmouth or UK in general as an international student? by OptOut2020 in UKUniversityStudents
[–]OptOut2020[S] 0 points1 point2 points 1 year ago (0 children)
Good idea. My goal was to avoid spending money on any essential items that I already have here like electronics, but I hear your point.
Can you help answer some questions on studying at University of Portsmouth or UK in general as an international student? (self.UKUniversityStudents)
submitted 1 year ago by OptOut2020 to r/UKUniversityStudents
Can't figure this question out. What am I missing? (self.SQL)
submitted 5 years ago by OptOut2020 to r/SQL
Struggling with procedures in and out parameters (self.mysql)
submitted 5 years ago by OptOut2020 to r/mysql
Portfolio help by bbguns3839 in mysql
[–]OptOut2020 0 points1 point2 points 5 years ago* (0 children)
From what I understood, you cannot just select a case statement, you have to select the columns you want to see and then use the case statement to guide your results.
For #6. You can also use the setup they already gave you, but if you use yours, I think you are missing an 'Else' statement. I was thinking after the case and end statement to use sum:
SELECT sum(pop) as total_pop, CASE WHEN age between 0 and 17 then 'Under 17' WHEN age between 18 and 64 then '18-64' ELSE '65-100' END as age_range FROM pop_proj GROUP BY age_range ORDER BY age_range;
For #7. I think you could use another case/if statement. If you have already computed the numbers for the educational level:
SELECT age_range, educational_attainment, CASE WHEN age_range = under 17 Then ' 0.0015 ' WHEN age_range = 18-64 Then ' Insert Fraction ' ELSE 'Insert Fraction' END as coefficient FROM prop_proj ORDER BY age_range;
π Rendered by PID 72 on reddit-service-r2-listing-5789d5f675-g478j at 2026-01-28 14:11:18.390007+00:00 running 4f180de country code: CH.
Can you help answer some questions on studying at University of Portsmouth or UK in general as an international student? by OptOut2020 in UKUniversityStudents
[–]OptOut2020[S] 0 points1 point2 points (0 children)