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": "Lenard",
  "family_name": "Muller",
  "middle_name": "Kris",
  "picture": "http://example.org/Lenard.jpg",
  "email": "Lenard.Muller@example.org",
  "name": "Lenard Kris Muller",
  "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:83322d691ce7a0514f25"
  },
  "iss": "https://lti-ri.imsglobal.org",
  "aud": "m123456",
  "iat": 1740260224,
  "exp": 1740260524,
  "sub": "b3fccec5f5864de2deac",
  "nonce": "c2c66fcd8e7880a25848",
  "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.eyJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9tZXNzYWdlX3R5cGUiOiJMdGlSZXNvdXJjZUxpbmtSZXF1ZXN0IiwiZ2l2ZW5fbmFtZSI6IkxlbmFyZCIsImZhbWlseV9uYW1lIjoiTXVsbGVyIiwibWlkZGxlX25hbWUiOiJLcmlzIiwicGljdHVyZSI6Imh0dHA6Ly9leGFtcGxlLm9yZy9MZW5hcmQuanBnIiwiZW1haWwiOiJMZW5hcmQuTXVsbGVyQGV4YW1wbGUub3JnIiwibmFtZSI6IkxlbmFyZCBLcmlzIE11bGxlciIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3JvbGVzIjpbImh0dHA6Ly9wdXJsLmltc2dsb2JhbC5vcmcvdm9jYWIvbGlzL3YyL21lbWJlcnNoaXAjTGVhcm5lciIsImh0dHA6Ly9wdXJsLmltc2dsb2JhbC5vcmcvdm9jYWIvbGlzL3YyL2luc3RpdHV0aW9uL3BlcnNvbiNTdHVkZW50IiwiaHR0cDovL3B1cmwuaW1zZ2xvYmFsLm9yZy92b2NhYi9saXMvdjIvbWVtYmVyc2hpcCNNZW50b3IiXSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vcm9sZV9zY29wZV9tZW50b3IiOlsiYTYyYzUyYzAyYmEyNjIwMDNmNWUiXSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vcmVzb3VyY2VfbGluayI6eyJpZCI6Ijc2MDYzIiwidGl0bGUiOiJTUUwgU0VMRUNUIERJU1RJTkNUIFN0YXRlbWVudCIsImRlc2NyaXB0aW9uIjoiVGhlIFNRTCBTRUxFQ1QgRElTVElOQ1QgU3RhdGVtZW50IFRoZSBTRUxFQ1QgRElTVElOQ1Qgc3RhdGVtZW50IGlzIHVzZWQgdG8gcmV0dXJuIG9ubHkgZGlzdGluY3QgKGRpZmZlcmVudCkgdmFsdWVzLiAgSW5zaWRlIGEgdGFibGUsIGEgY29sdW1uIG9mdGVuIGNvbnRhaW5zIG1hbnkgZHVwbGljYXRlIHZhbHVlczsgYW5kIHNvbWV0aW1lcyB5b3Ugb25seSB3YW50IHRvIGxpc3QgdGhlIGRpZmZlcmVudCAoZGlzdGluY3QpIHZhbHVlcy4gIFNFTEVDVCBESVNUSU5DVCBTeW50YXggU0VMRUNUIERJU1RJTkNUIGNvbHVtbjEsIGNvbHVtbjIsIC4uLiBGUk9NIHRhYmxlX25hbWU7In0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2NvbnRleHQiOnsiaWQiOiI1NTI1NSIsImxhYmVsIjoiVHV0b3JpYWwiLCJ0aXRsZSI6IlNRTCBUdXRvcmlhbCIsInR5cGUiOlsiZGF0YWJhc2UiXX0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3Rvb2xfcGxhdGZvcm0iOnsibmFtZSI6Ik1ldGF0dWRlX3BsYXRmcm9tIiwiY29udGFjdF9lbWFpbCI6IiIsImRlc2NyaXB0aW9uIjoiIiwidXJsIjoiIiwicHJvZHVjdF9mYW1pbHlfY29kZSI6IiIsInZlcnNpb24iOiIxLjAiLCJndWlkIjoiNDIzMCJ9LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1hZ3MvY2xhaW0vZW5kcG9pbnQiOnsic2NvcGUiOlsiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktYWdzL3Njb3BlL2xpbmVpdGVtIiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktYWdzL3Njb3BlL3Jlc3VsdC5yZWFkb25seSIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWFncy9zY29wZS9zY29yZSJdLCJsaW5laXRlbXMiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnL3BsYXRmb3Jtcy80MjMwL2NvbnRleHRzLzU1MjU1L2xpbmVfaXRlbXMifSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktbnJwcy9jbGFpbS9uYW1lc3JvbGVzZXJ2aWNlIjp7ImNvbnRleHRfbWVtYmVyc2hpcHNfdXJsIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9wbGF0Zm9ybXMvNDIzMC9jb250ZXh0cy81NTI1NS9tZW1iZXJzaGlwcyIsInNlcnZpY2VfdmVyc2lvbnMiOlsiMi4wIl19LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1jZXMvY2xhaW0vY2FsaXBlci1lbmRwb2ludC1zZXJ2aWNlIjp7InNjb3BlcyI6WyJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1jZXMvdjFwMC9zY29wZS9zZW5kIl0sImNhbGlwZXJfZW5kcG9pbnRfdXJsIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9wbGF0Zm9ybXMvNDIzMC9zZW5zb3JzIiwiY2FsaXBlcl9mZWRlcmF0ZWRfc2Vzc2lvbl9pZCI6InVybjp1dWlkOjgzMzIyZDY5MWNlN2EwNTE0ZjI1In0sImlzcyI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmciLCJhdWQiOiJtMTIzNDU2IiwiaWF0IjoxNzQwMjYwMjI0LCJleHAiOjE3NDAyNjA1MjQsInN1YiI6ImIzZmNjZWM1ZjU4NjRkZTJkZWFjIiwibm9uY2UiOiJjMmM2NmZjZDhlNzg4MGEyNTg0OCIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3ZlcnNpb24iOiIxLjMuMCIsImxvY2FsZSI6ImVuLVVTIiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vbGF1bmNoX3ByZXNlbnRhdGlvbiI6eyJkb2N1bWVudF90YXJnZXQiOiJpZnJhbWUiLCJoZWlnaHQiOjMyMCwid2lkdGgiOjI0MCwicmV0dXJuX3VybCI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvcGxhdGZvcm1zLzQyMzAvcmV0dXJucyJ9LCJodHRwczovL3d3dy5leGFtcGxlLmNvbS9leHRlbnNpb24iOnsiY29sb3IiOiJ2aW9sZXQifSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vY3VzdG9tIjp7Im15Q3VzdG9tVmFsdWUiOiIxMjMifSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vZGVwbG95bWVudF9pZCI6IjEiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS90YXJnZXRfbGlua191cmkiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnL2x0aS90b29scy8yODA5L2xhdW5jaGVzIn0.E-RlgmMZgZUqy19xsvU8WYILEu3EgwauRckYiDml4o4L62nJpXTpWAA8iRckTwscuTpNdgf2DFWVG9ox8fHdQ9N4cb420U6tx4TPnaT8sYTeXcHCooyKEl-eZYQIn75IT_Ixcd7WnIhDclRUROby570RvmbJVTHPOVnIMcD_hGU-onBkMRMprcB0nB58ZhanYaeFk5bxGUle9it-huvuZSUbq7VH2bFISonC15Bu714jJ6nFt137GcTU7b0LVDLdDFveoGGBj0RaG20ZDjEULTq2xAtxK1kpQwn9m5e79L8Rq8LQHCdP2MipuDssQ8K04-wyip-QTv3t4e5MK9q2_A

Launch