any626

Location: Los Angeles, CA or Orange County, CA

Remote: Yes and preferred

Willing to relocate: No

Technologies: Backend Engineer with experience in Golang, Java, and PHP.

Résumé/CV: https://www.linkedin.com/in/alejandrolanderos/

   I have experience working at a startup and a large company (Amazon).

Backend dev here. How can one learn these types of skills? Recommendations?

Screenshot: https://imgur.com/a/qocmdE1

Depends

You could have

    property_id, user_id, value(string)
    1 (assume age), 1213,    60
    2 (gender),     1213,    female

    property_id, user_id, value_str, value_int
    1 (assume age), 1213,    null, 60
    2 (gender),     1213,    female, null

You would need to have a new join for each new property

    SELECT DISTINCT loyaltyMemberID
    from members as m
    INNER JOIN properties as p1 on m.id = p1.user_id
    INNER JOIN properties as p2 on m.id = p2.user_id
    INNER JOIN properties as p3 on m.id = p3.user_id
    AND (p1.prop = 'gender' AND p1.value = x)
    AND ((p2.prop = 'age' AND p2.value = y) OR (p3.prop = 'censor' AND p3.value = z))

The user data is most likely in rows instead of columns. Instead of having

    id, name, age, gender
    1213, fake, 60, female

    property_id, user_id, value
    1 (assume age), 1213,    60
    2 (gender),     1213,    female

That did it! Thank you very much. What do you recommend for the number of shapes when creating a gif?

Very cool. How did you create the gif? I tried -o filename.gif but i got nothing.