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": "Ms.",
  "family_name": "Wiegand",
  "middle_name": "Leontine",
  "picture": "http://example.org/Ms..jpg",
  "email": "Ms..Wiegand@example.org",
  "name": "Ms. Leontine Emmerich Wiegand",
  "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:111efa1b332fda123e2d"
  },
  "iss": "https://lti-ri.imsglobal.org",
  "aud": "m123456",
  "iat": 1782472699,
  "exp": 1782472999,
  "sub": "6117b784e6bccec755e3",
  "nonce": "de3eeb16262926abce76",
  "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.eyJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9tZXNzYWdlX3R5cGUiOiJMdGlSZXNvdXJjZUxpbmtSZXF1ZXN0IiwiZ2l2ZW5fbmFtZSI6Ik1zLiIsImZhbWlseV9uYW1lIjoiV2llZ2FuZCIsIm1pZGRsZV9uYW1lIjoiTGVvbnRpbmUiLCJwaWN0dXJlIjoiaHR0cDovL2V4YW1wbGUub3JnL01zLi5qcGciLCJlbWFpbCI6Ik1zLi5XaWVnYW5kQGV4YW1wbGUub3JnIiwibmFtZSI6Ik1zLiBMZW9udGluZSBFbW1lcmljaCBXaWVnYW5kIiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vcm9sZXMiOlsiaHR0cDovL3B1cmwuaW1zZ2xvYmFsLm9yZy92b2NhYi9saXMvdjIvbWVtYmVyc2hpcCNMZWFybmVyIiwiaHR0cDovL3B1cmwuaW1zZ2xvYmFsLm9yZy92b2NhYi9saXMvdjIvaW5zdGl0dXRpb24vcGVyc29uI1N0dWRlbnQiLCJodHRwOi8vcHVybC5pbXNnbG9iYWwub3JnL3ZvY2FiL2xpcy92Mi9tZW1iZXJzaGlwI01lbnRvciJdLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9yb2xlX3Njb3BlX21lbnRvciI6WyJhNjJjNTJjMDJiYTI2MjAwM2Y1ZSJdLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9yZXNvdXJjZV9saW5rIjp7ImlkIjoiNzYwNjMiLCJ0aXRsZSI6IlNRTCBTRUxFQ1QgRElTVElOQ1QgU3RhdGVtZW50IiwiZGVzY3JpcHRpb24iOiJUaGUgU1FMIFNFTEVDVCBESVNUSU5DVCBTdGF0ZW1lbnQgVGhlIFNFTEVDVCBESVNUSU5DVCBzdGF0ZW1lbnQgaXMgdXNlZCB0byByZXR1cm4gb25seSBkaXN0aW5jdCAoZGlmZmVyZW50KSB2YWx1ZXMuICBJbnNpZGUgYSB0YWJsZSwgYSBjb2x1bW4gb2Z0ZW4gY29udGFpbnMgbWFueSBkdXBsaWNhdGUgdmFsdWVzOyBhbmQgc29tZXRpbWVzIHlvdSBvbmx5IHdhbnQgdG8gbGlzdCB0aGUgZGlmZmVyZW50IChkaXN0aW5jdCkgdmFsdWVzLiAgU0VMRUNUIERJU1RJTkNUIFN5bnRheCBTRUxFQ1QgRElTVElOQ1QgY29sdW1uMSwgY29sdW1uMiwgLi4uIEZST00gdGFibGVfbmFtZTsifSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vY29udGV4dCI6eyJpZCI6IjU1MjU1IiwibGFiZWwiOiJUdXRvcmlhbCIsInRpdGxlIjoiU1FMIFR1dG9yaWFsIiwidHlwZSI6WyJkYXRhYmFzZSJdfSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vdG9vbF9wbGF0Zm9ybSI6eyJuYW1lIjoiTWV0YXR1ZGVfcGxhdGZyb20iLCJjb250YWN0X2VtYWlsIjoiIiwiZGVzY3JpcHRpb24iOiIiLCJ1cmwiOiIiLCJwcm9kdWN0X2ZhbWlseV9jb2RlIjoiIiwidmVyc2lvbiI6IjEuMCIsImd1aWQiOiI0MjMwIn0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWFncy9jbGFpbS9lbmRwb2ludCI6eyJzY29wZSI6WyJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1hZ3Mvc2NvcGUvbGluZWl0ZW0iLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1hZ3Mvc2NvcGUvcmVzdWx0LnJlYWRvbmx5IiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktYWdzL3Njb3BlL3Njb3JlIl0sImxpbmVpdGVtcyI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvcGxhdGZvcm1zLzQyMzAvY29udGV4dHMvNTUyNTUvbGluZV9pdGVtcyJ9LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1ucnBzL2NsYWltL25hbWVzcm9sZXNlcnZpY2UiOnsiY29udGV4dF9tZW1iZXJzaGlwc191cmwiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnL3BsYXRmb3Jtcy80MjMwL2NvbnRleHRzLzU1MjU1L21lbWJlcnNoaXBzIiwic2VydmljZV92ZXJzaW9ucyI6WyIyLjAiXX0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWNlcy9jbGFpbS9jYWxpcGVyLWVuZHBvaW50LXNlcnZpY2UiOnsic2NvcGVzIjpbImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWNlcy92MXAwL3Njb3BlL3NlbmQiXSwiY2FsaXBlcl9lbmRwb2ludF91cmwiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnL3BsYXRmb3Jtcy80MjMwL3NlbnNvcnMiLCJjYWxpcGVyX2ZlZGVyYXRlZF9zZXNzaW9uX2lkIjoidXJuOnV1aWQ6MTExZWZhMWIzMzJmZGExMjNlMmQifSwiaXNzIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZyIsImF1ZCI6Im0xMjM0NTYiLCJpYXQiOjE3ODI0NzI2OTksImV4cCI6MTc4MjQ3Mjk5OSwic3ViIjoiNjExN2I3ODRlNmJjY2VjNzU1ZTMiLCJub25jZSI6ImRlM2VlYjE2MjYyOTI2YWJjZTc2IiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vdmVyc2lvbiI6IjEuMy4wIiwibG9jYWxlIjoiZW4tVVMiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9sYXVuY2hfcHJlc2VudGF0aW9uIjp7ImRvY3VtZW50X3RhcmdldCI6ImlmcmFtZSIsImhlaWdodCI6MzIwLCJ3aWR0aCI6MjQwLCJyZXR1cm5fdXJsIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9wbGF0Zm9ybXMvNDIzMC9yZXR1cm5zIn0sImh0dHBzOi8vd3d3LmV4YW1wbGUuY29tL2V4dGVuc2lvbiI6eyJjb2xvciI6InZpb2xldCJ9LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9jdXN0b20iOnsibXlDdXN0b21WYWx1ZSI6IjEyMyJ9LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9kZXBsb3ltZW50X2lkIjoiMSIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3RhcmdldF9saW5rX3VyaSI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvbHRpL3Rvb2xzLzI4MDkvbGF1bmNoZXMifQ.Hl-g9eyLL2_NuGczqkRwMFPtW72qqdgwGWVNO9VUoBkhlXEWzFVIY3FUxz5U0mm-IkXwDJKVbofN7qfEe7muk1I1HkQ1G1nOfhjpB3RgwiDnXKT4XgWJhT6nncFr-m_TASA8xd1D4YSV4l2mzZRxsX_8PEtzuTkbOix7OkMitwbnAdbePvgyUKJ20eTZbXwniIRF4xLlOelR2ZS-T981GxScSNZFSDc9YN3hYItogdaxQI3SWCdI4NiSgK-gSEBCgTadhC8RDjHiampgKud3ULDw90Ogu_yxDjAchAxEh3Iq_0iLgUySnQHG-ONqIB8uVT8Sl0ZBwvOLIt6FqTzRgQ

Launch