How should I practice Social Network Relationship Statistics?

Start by reading the full statement, solve the visible examples, then compare the pattern against related IBM online assessment problems in FastPrep.

Is Social Network Relationship Statistics associated with IBM?

FastPrep tags this as a IBM online assessment coding practice problem when the problem catalog has that company and stage context.

Social Network Relationship Statistics

IBM● EasyINTERNOA

Problem statement

Generate a report of social-network profiles and their relationship statistics.

Return one row for every profile with these columns in order:

full_name, formatted as last_name, one space, then first_name.
email.
total_relations, the total number of rows in relations for the profile.
approved_relations, the number of relationships whose is_approved value is true.
pending_relations, the number of relationships whose is_approved value is false.

Profiles with no relationship rows must still appear with all three counts equal to 0. Sort the result by full_name in ascending order, then by email in ascending order when full names are equal.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

profiles

Social-network profile records.

Column	Type	Nullable	Description
idPK	Integer	No	Profile ID.
first_name	Text	No	Profile first name.
last_name	Text	No	Profile last name.
email	Text	No	Profile email address.

relations

Relationship rows belonging to profiles.

Column	Type	Nullable	Description
profile_id	Integer	No	Profile that owns the relationship.
related_to	Text	No	Identifier of the related profile or account.
is_approved	Boolean	No	Whether the relationship is approved.

Foreign key: profile_id → profiles(id)

Expected result

Your query or function must return these columns.

Column	Type	Nullable	Description
full_name	Text	No	—
email	Text	No	—
total_relations	Integer	No	—
approved_relations	Integer	No	—
pending_relations	Integer	No	—

Row order: must match exactly. Numeric tolerance: 0.

Constraints

profiles.id is unique and identifies one profile.
Every relations.profile_id references an existing profiles.id.
relations.is_approved is either true or false.
Each row in relations counts as one relationship, even when related_to values repeat.
Profiles with no relationship rows have zero total, approved, and pending relationships.
Rows with equal full_name values are ordered by email in ascending order.