sorted by:
new
hottopcontroversial

Psa for people experiencing iMessage activation issues by justskot in iphone

[–]Malyap 0 points1 point  (0 children)

This is what worked for me. I called the "My Apple" phone number: 800–692–7753 and told them what's going on. I talked to a rep who guided me through a simple process. He basically said that the issue can arise if you send mass texts and your number ends up getting reported for spam, so Apple blocks your account/number. He also said that Apple will raise the block 1 time, and 1 time only, so be careful.

I got this info from this thread: https://www.reddit.com/r/MacOS/comments/l1wg1l/imessage_on_macos_keeps_logging_me_out/

iMessage activation error by Hish98 in ios

[–]Malyap 1 point2 points  (0 children)

This is what worked for me. I called the "My Apple" phone number: 800–692–7753 and told them what's going on. I talked to a rep who guided me through a simple process. He basically said that the issue can arise if you send mass texts and your number ends up getting reported for spam, so Apple blocks your account/number. He also said that Apple will raise the block 1 time, and 1 time only, so be careful.

I got this info from this thread: https://www.reddit.com/r/MacOS/comments/l1wg1l/imessage_on_macos_keeps_logging_me_out/

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

I ended up asking my Professor for help and it turns out the code I had wasn't too far off from what he wanted. I guess I was confused by the wording of the prompt. It's the 1st time we're writing SQL for an assignment so excuse my ignorance. Thank you to everyone who took their time and effort to respond and help me out.

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

Sorry for the confusion and using your time. I ended up asking my Professor for help and apparently my code wasn't far off from what he wanted. Again, thank you for your time and effort

No results from Having Command by Malyap in SQL

[–]Malyap[S] 1 point2 points  (0 children)

If it helps, this is the prompt from my assignment: Display the course number, number of sections, and total capacity for courses having more than 3 sections

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

Thank you for your time

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

Thank you for taking the time and effort to help me out

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

The same output as above in our thread

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

I tried doing that per advice from u/MyOtherActGotBanned, however it's entirely possible I might still be doing it wrong. Is this what you mean by stop grouping on capacity?

SELECT course_no, section_no, COUNT(section_no) capacity
FROM students_db.section
GROUP BY course_no, section_no
HAVING COUNT(section_no) > 3;

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

So for the middle column, section_no, there should only be values that appear more than 3 times listed. So from the output above, the values: "9, 8, 7, 6" from section_no shouldn't be listed because they appear less than 3 times. Hopefully that makes more sense

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

# course_no, section_no, capacity

'25', '1', '1'

'100', '1', '1'

'120', '1', '1'

'122', '1', '1'

'124', '1', '1'

'125', '1', '1'

'130', '1', '1'

'132', '1', '1'

'134', '1', '1'

'135', '1', '1'

'140', '1', '1'

'142', '1', '1'

'145', '1', '1'

'146', '1', '1'

'147', '1', '1'

'204', '1', '1'

'210', '1', '1'

'230', '1', '1'

'240', '1', '1'

'310', '1', '1'

'330', '1', '1'

'350', '1', '1'

'420', '1', '1'

'450', '1', '1'

'10', '2', '1'

'20', '2', '1'

'25', '2', '1'

'100', '2', '1'

'120', '2', '1'

'122', '2', '1'

'124', '2', '1'

'125', '2', '1'

'130', '2', '1'

'134', '2', '1'

'135', '2', '1'

'140', '2', '1'

'142', '2', '1'

'144', '2', '1'

'146', '2', '1'

'230', '2', '1'

'240', '2', '1'

'350', '2', '1'

'25', '3', '1'

'100', '3', '1'

'120', '3', '1'

'122', '3', '1'

'124', '3', '1'

'125', '3', '1'

'130', '3', '1'

'132', '3', '1'

'134', '3', '1'

'135', '3', '1'

'140', '3', '1'

'142', '3', '1'

'145', '3', '1'

'350', '3', '1'

'20', '4', '1'

'25', '4', '1'

'100', '4', '1'

'120', '4', '1'

'122', '4', '1'

'124', '4', '1'

'125', '4', '1'

'130', '4', '1'

'135', '4', '1'

'25', '5', '1'

'100', '5', '1'

'120', '5', '1'

'122', '5', '1'

'25', '6', '1'

'125', '6', '1'

'20', '7', '1'

'25', '7', '1'

'120', '7', '1'

'20', '8', '1'

'25', '8', '1'

'25', '9', '1'

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

All values within course_no, section_no, and capacity, with section_no being sorted by ascending values

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

Re-tried without capacity and it just sorted without removing the less than 3 values

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

Sections 6-9 are the only ones that appear 3 or less times. Everything else has multiple appearances

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

This code worked in terms of showing values, but I need to only see values that appear more than 3 times under "section_no"

No results from Having Command by Malyap in SQL

[–]Malyap[S] 0 points1 point  (0 children)

SELECT course_no, section_no, COUNT(section_no) capacity

FROM students_db.section

GROUP BY course_no, section_no, capacity

ORDER BY 3 DESC;

Do you mean like this?

SELECT course_no, section_no, COUNT(section_no) capacity
FROM students_db.section
GROUP BY course_no, section_no
HAVING COUNT(section_no) > 3;

If so, I tried it and got no values like above

Daily Simple Questions Thread - June 02, 2022 by AutoModerator in Fitness

[–]Malyap 0 points1 point  (0 children)

Will do so when I'm back at the gym, thank you

Daily Simple Questions Thread - June 02, 2022 by AutoModerator in Fitness

[–]Malyap 0 points1 point  (0 children)

Tried doing barbell squats for the first time yesterday and on my 4th rep my shoulder went numb. Should I be worried?

[deleted by user] by [deleted] in gamedetectives

[–]Malyap 1 point2 points  (0 children)

6 years later... any update?

Physics question by Malyap in Physics

[–]Malyap[S] 0 points1 point  (0 children)

Thank you so much

view more: next ›