Platform: Metatude_platfrom

Context: SQL Tutorial

Title: SQL SELECT DISTINCT Statement

Description: The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values. SELECT DISTINCT Syntax SELECT DISTINCT column1, column2, ... FROM table_name;

JWT attributes in request:

{
  "https://purl.imsglobal.org/spec/lti/claim/message_type": "LtiResourceLinkRequest",
  "given_name": "Bryon",
  "family_name": "II",
  "middle_name": "Lehner",
  "picture": "http://example.org/Bryon.jpg",
  "email": "Bryon.II@example.org",
  "name": "Bryon Lehner Crooks II",
  "https://purl.imsglobal.org/spec/lti/claim/roles": [
    "http://purl.imsglobal.org/vocab/lis/v2/membership#Learner",
    "http://purl.imsglobal.org/vocab/lis/v2/institution/person#Student",
    "http://purl.imsglobal.org/vocab/lis/v2/membership#Mentor"
  ],
  "https://purl.imsglobal.org/spec/lti/claim/role_scope_mentor": [
    "a62c52c02ba262003f5e"
  ],
  "https://purl.imsglobal.org/spec/lti/claim/resource_link": {
    "id": "76063",
    "title": "SQL SELECT DISTINCT Statement",
    "description": "The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (different) values.  Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.  SELECT DISTINCT Syntax SELECT DISTINCT column1, column2, ... FROM table_name;"
  },
  "https://purl.imsglobal.org/spec/lti/claim/context": {
    "id": "55255",
    "label": "Tutorial",
    "title": "SQL Tutorial",
    "type": [
      "database"
    ]
  },
  "https://purl.imsglobal.org/spec/lti/claim/tool_platform": {
    "name": "Metatude_platfrom",
    "contact_email": "",
    "description": "",
    "url": "",
    "product_family_code": "",
    "version": "1.0",
    "guid": "4230"
  },
  "https://purl.imsglobal.org/spec/lti-ags/claim/endpoint": {
    "scope": [
      "https://purl.imsglobal.org/spec/lti-ags/scope/lineitem",
      "https://purl.imsglobal.org/spec/lti-ags/scope/result.readonly",
      "https://purl.imsglobal.org/spec/lti-ags/scope/score"
    ],
    "lineitems": "https://lti-ri.imsglobal.org/platforms/4230/contexts/55255/line_items"
  },
  "https://purl.imsglobal.org/spec/lti-nrps/claim/namesroleservice": {
    "context_memberships_url": "https://lti-ri.imsglobal.org/platforms/4230/contexts/55255/memberships",
    "service_versions": [
      "2.0"
    ]
  },
  "https://purl.imsglobal.org/spec/lti-ces/claim/caliper-endpoint-service": {
    "scopes": [
      "https://purl.imsglobal.org/spec/lti-ces/v1p0/scope/send"
    ],
    "caliper_endpoint_url": "https://lti-ri.imsglobal.org/platforms/4230/sensors",
    "caliper_federated_session_id": "urn:uuid:4038af8903eea283efb8"
  },
  "iss": "https://lti-ri.imsglobal.org",
  "aud": "m123456",
  "iat": 1759993499,
  "exp": 1759993799,
  "sub": "9fee074085c3c0447f5a",
  "nonce": "5a1c26224e26849fbe39",
  "https://purl.imsglobal.org/spec/lti/claim/version": "1.3.0",
  "locale": "en-US",
  "https://purl.imsglobal.org/spec/lti/claim/launch_presentation": {
    "document_target": "iframe",
    "height": 320,
    "width": 240,
    "return_url": "https://lti-ri.imsglobal.org/platforms/4230/returns"
  },
  "https://www.example.com/extension": {
    "color": "violet"
  },
  "https://purl.imsglobal.org/spec/lti/claim/custom": {
    "myCustomValue": "123"
  },
  "https://purl.imsglobal.org/spec/lti/claim/deployment_id": "1",
  "https://purl.imsglobal.org/spec/lti/claim/target_link_uri": "https://lti-ri.imsglobal.org/lti/tools/2809/launches"
}

JWT that will be sent:

eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImtpZCI6IjVHWFgzVTlQNklnMGRBNDNBZThiWXhsS1g5d0VWblZqRmtfeThLNHlrbUEifQ.eyJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9tZXNzYWdlX3R5cGUiOiJMdGlSZXNvdXJjZUxpbmtSZXF1ZXN0IiwiZ2l2ZW5fbmFtZSI6IkJyeW9uIiwiZmFtaWx5X25hbWUiOiJJSSIsIm1pZGRsZV9uYW1lIjoiTGVobmVyIiwicGljdHVyZSI6Imh0dHA6Ly9leGFtcGxlLm9yZy9Ccnlvbi5qcGciLCJlbWFpbCI6IkJyeW9uLklJQGV4YW1wbGUub3JnIiwibmFtZSI6IkJyeW9uIExlaG5lciBDcm9va3MgSUkiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9yb2xlcyI6WyJodHRwOi8vcHVybC5pbXNnbG9iYWwub3JnL3ZvY2FiL2xpcy92Mi9tZW1iZXJzaGlwI0xlYXJuZXIiLCJodHRwOi8vcHVybC5pbXNnbG9iYWwub3JnL3ZvY2FiL2xpcy92Mi9pbnN0aXR1dGlvbi9wZXJzb24jU3R1ZGVudCIsImh0dHA6Ly9wdXJsLmltc2dsb2JhbC5vcmcvdm9jYWIvbGlzL3YyL21lbWJlcnNoaXAjTWVudG9yIl0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3JvbGVfc2NvcGVfbWVudG9yIjpbImE2MmM1MmMwMmJhMjYyMDAzZjVlIl0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3Jlc291cmNlX2xpbmsiOnsiaWQiOiI3NjA2MyIsInRpdGxlIjoiU1FMIFNFTEVDVCBESVNUSU5DVCBTdGF0ZW1lbnQiLCJkZXNjcmlwdGlvbiI6IlRoZSBTUUwgU0VMRUNUIERJU1RJTkNUIFN0YXRlbWVudCBUaGUgU0VMRUNUIERJU1RJTkNUIHN0YXRlbWVudCBpcyB1c2VkIHRvIHJldHVybiBvbmx5IGRpc3RpbmN0IChkaWZmZXJlbnQpIHZhbHVlcy4gIEluc2lkZSBhIHRhYmxlLCBhIGNvbHVtbiBvZnRlbiBjb250YWlucyBtYW55IGR1cGxpY2F0ZSB2YWx1ZXM7IGFuZCBzb21ldGltZXMgeW91IG9ubHkgd2FudCB0byBsaXN0IHRoZSBkaWZmZXJlbnQgKGRpc3RpbmN0KSB2YWx1ZXMuICBTRUxFQ1QgRElTVElOQ1QgU3ludGF4IFNFTEVDVCBESVNUSU5DVCBjb2x1bW4xLCBjb2x1bW4yLCAuLi4gRlJPTSB0YWJsZV9uYW1lOyJ9LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9jb250ZXh0Ijp7ImlkIjoiNTUyNTUiLCJsYWJlbCI6IlR1dG9yaWFsIiwidGl0bGUiOiJTUUwgVHV0b3JpYWwiLCJ0eXBlIjpbImRhdGFiYXNlIl19LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS90b29sX3BsYXRmb3JtIjp7Im5hbWUiOiJNZXRhdHVkZV9wbGF0ZnJvbSIsImNvbnRhY3RfZW1haWwiOiIiLCJkZXNjcmlwdGlvbiI6IiIsInVybCI6IiIsInByb2R1Y3RfZmFtaWx5X2NvZGUiOiIiLCJ2ZXJzaW9uIjoiMS4wIiwiZ3VpZCI6IjQyMzAifSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktYWdzL2NsYWltL2VuZHBvaW50Ijp7InNjb3BlIjpbImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWFncy9zY29wZS9saW5laXRlbSIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWFncy9zY29wZS9yZXN1bHQucmVhZG9ubHkiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1hZ3Mvc2NvcGUvc2NvcmUiXSwibGluZWl0ZW1zIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9wbGF0Zm9ybXMvNDIzMC9jb250ZXh0cy81NTI1NS9saW5lX2l0ZW1zIn0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLW5ycHMvY2xhaW0vbmFtZXNyb2xlc2VydmljZSI6eyJjb250ZXh0X21lbWJlcnNoaXBzX3VybCI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvcGxhdGZvcm1zLzQyMzAvY29udGV4dHMvNTUyNTUvbWVtYmVyc2hpcHMiLCJzZXJ2aWNlX3ZlcnNpb25zIjpbIjIuMCJdfSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktY2VzL2NsYWltL2NhbGlwZXItZW5kcG9pbnQtc2VydmljZSI6eyJzY29wZXMiOlsiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktY2VzL3YxcDAvc2NvcGUvc2VuZCJdLCJjYWxpcGVyX2VuZHBvaW50X3VybCI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvcGxhdGZvcm1zLzQyMzAvc2Vuc29ycyIsImNhbGlwZXJfZmVkZXJhdGVkX3Nlc3Npb25faWQiOiJ1cm46dXVpZDo0MDM4YWY4OTAzZWVhMjgzZWZiOCJ9LCJpc3MiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnIiwiYXVkIjoibTEyMzQ1NiIsImlhdCI6MTc1OTk5MzQ5OSwiZXhwIjoxNzU5OTkzNzk5LCJzdWIiOiI5ZmVlMDc0MDg1YzNjMDQ0N2Y1YSIsIm5vbmNlIjoiNWExYzI2MjI0ZTI2ODQ5ZmJlMzkiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS92ZXJzaW9uIjoiMS4zLjAiLCJsb2NhbGUiOiJlbi1VUyIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2xhdW5jaF9wcmVzZW50YXRpb24iOnsiZG9jdW1lbnRfdGFyZ2V0IjoiaWZyYW1lIiwiaGVpZ2h0IjozMjAsIndpZHRoIjoyNDAsInJldHVybl91cmwiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnL3BsYXRmb3Jtcy80MjMwL3JldHVybnMifSwiaHR0cHM6Ly93d3cuZXhhbXBsZS5jb20vZXh0ZW5zaW9uIjp7ImNvbG9yIjoidmlvbGV0In0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2N1c3RvbSI6eyJteUN1c3RvbVZhbHVlIjoiMTIzIn0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2RlcGxveW1lbnRfaWQiOiIxIiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vdGFyZ2V0X2xpbmtfdXJpIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9sdGkvdG9vbHMvMjgwOS9sYXVuY2hlcyJ9.Tn984MrI1VNqjsARO2OlGrl4b4m7fenSscPuNZtzPxNQ8w-WZjOmLxqhYlC9P1JG7MEz7p4jUozkIx2H_anvp8e_nQ68nl1-UoqmXaZBcdRs6bZkw5OL1kIjI-QI9QCiHViPGoKcoVcYltsDzvNro5UH9xVZiWoBxuvMxQLx6EH7rjOGEVC55D41gHFSXMNqIymGxxBDROaAn83ZtWItuLB531c58Ao7MW50m6kRolHamm9nUo4o7alOW0IqNu4BbxpkU-_9A8SKKR9DBEVtfIltiPDcx0mO8je6FaeoLqDmaZwRlXSaFexihCztFFHaLLRHQb8YHxERIk_KpIhKKg

Launch