PS3 | multi-threaded password checker

I am trying to create a select in bash that lets you select items from a .txt file. Each item is a new line, I read the items and put them in an array using:

...

I have 4 subjects that can be graded i.e. Math's, Science, English, Geography. Each subject is graded on a proficiency scale from 1-5, i.e PS1, PS2, PS3, PS4, PS5, where PS2 is better than PS1, PS3 is better than PS2 and so on.

To pass, students would need to score at least 2 PL2 and 2 PL1 (in any combination for all 4 subjects).

Student Maths Science English Social Studies Expected Result Anna PS2 PS1 NA PS3 Fail Ben PS2 PS4 PS1 PS3 Pass Clare PS1 PS1 PS3 PS3 Pass

How can I write an excel formula to generate column F "Expected Result"?

...

With the below code:

...

I have to query a legacy MySQL database and export the results as a CSV file. It is on a relatively locked-down system so the solution has to be SQL only.

The problematic table, dbo.NGSVariantACMG, has 23 fields each relating to a category of evidence called PVS1, PS1, PS2 etc. Each of these fields accepts a value of null, '3366', '3367', '3368', or '3369', which rate the strength of the evidence in that category for each row. These values link to human readable descriptions, 'Very Strong', 'Strong', 'Moderate', 'Supporting' respectively, which can be looked up in another table called item, which has become something of a dumping ground for many different lookup values.

Example of the data:

PersonID PVS1 PS1 PS2 ... 1 null null '3367' ... 2 '3368' '3366' null ... 3 null '3369' '3369' ...

Rather than the arbitary 4 digit string I would like to export the data in a human readable format:

Person PVS1 PS1 PS2 ... 1 null null 'Strong' ... 2 'Moderate' 'Very Strong' null ... 3 null 'Supporting' 'Supporting' ...

The query I wrote below works fine, however I'm sure there is a more elegant way of doing it. Basically, I avoid using the item table to look up the relevant human readable description and use a conditional CASE statement for each field:

...

I have a MySQL database table named questions having the following columns:

id, question, category, type, difficulty, correct_answer, incorrect_answer_1, incorrect_answer_2, incorrect_answer_3

I need to output data from this table into JSON format but in the following specific format only (like incorrect answers clubbed together):

...

When I try to use overflow: hidden;, the result isn't that I expect. The article has the good size on big screens, but on small screens, the text is too big so it's over the article..

...

Given a vector of numbers v, I can access sums of sections of this vector by using cumulative sums, i.e., instead of O(n)

...

So, i don't know if the title makes it easy to understand, but basically i want to change this to the minimum of code possible:

...

I have the following code where the user picks a file type, then I run certain code for each case:

...