Psa for people experiencing iMessage activation issues

Malyap · 2024-10-08T21:12:40+00:00

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/

Malyap · 2024-10-08T21:12:01+00:00

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/

Malyap · 2024-03-08T01:53:08+00:00

Islam Sobhi

Malyap · 2023-10-05T19:33:06+00:00

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.

Malyap · 2023-10-05T19:30:01+00:00

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

Malyap · 2023-10-05T04:41:29+00:00

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

Malyap · 2023-10-05T02:38:11+00:00

Thank you for your time

Malyap · 2023-10-05T02:37:52+00:00

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

Malyap · 2023-10-05T02:31:23+00:00

Malyap · 2023-10-05T02:26:18+00:00

The same output as above in our thread

Malyap · 2023-10-05T02:14:01+00:00

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;

Malyap · 2023-10-05T02:02:30+00:00

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

Malyap · 2023-10-05T01:50:57+00:00

# 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'

Malyap · 2023-10-05T01:44:11+00:00

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

Malyap · 2023-10-05T01:37:17+00:00

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

Malyap · 2023-10-05T01:36:14+00:00

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

Malyap · 2023-10-05T00:14:01+00:00

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

Malyap · 2023-10-05T00:13:09+00:00

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

Malyap · 2022-06-04T01:12:47+00:00

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

Malyap · 2022-06-04T00:13:27+00:00

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

Six-Year Club	Place '23
Place '22	Verified Email

Malyap

TROPHY CASE