rootProject.name='leetcode-in-java'

rootProject.name='LeetCode-in-Java'

packageg1001_1100.s1061_lexicographically_smallest_equivalent_string;

publicclassSolution {

privateint[]parent;

publicStringsmallestEquivalentString(Strings1,Strings2,StringbaseStr) {

parent =newint[26];

intn =s1.length();

StringBuilderresult =newStringBuilder();

for (inti =0;i <26;i++) {

parent[i] =i;

}

for (inti =0;i <n;i++) {

union(s1.charAt(i) -'a',s2.charAt(i) -'a');

}

charbase ='a';

for (charelement :baseStr.toCharArray()) {

result.append(Character.toString(base +find(element -'a')));

}

returnresult.toString();

}

privatevoidunion(inta,intb) {

intparentA =find(a);

intparentB =find(b);

if (parentA !=parentB) {

if (parentA <parentB) {

parent[parentB] =parentA;

}else {

parent[parentA] =parentB;

}

}

}

privateintfind(intx) {

while (parent[x] !=x) {

x =parent[x];

}

returnx;

}

}

1061\. Lexicographically Smallest Equivalent String

Medium

You are given two strings of the same length`s1` and`s2` and a string`baseStr`.

We say`s1[i]` and`s2[i]` are equivalent characters.

* For example, if`s1 = "abc"` and`s2 = "cde"`, then we have`'a' == 'c'`,`'b' == 'd'`, and`'c' == 'e'`.

Equivalent characters follow the usual rules of any equivalence relation:

***Reflexivity:**`'a' == 'a'`.

***Symmetry:**`'a' == 'b'` implies`'b' == 'a'`.

***Transitivity:**`'a' == 'b'` and`'b' == 'c'` implies`'a' == 'c'`.

For example, given the equivalency information from`s1 = "abc"` and`s2 = "cde"`,`"acd"` and`"aab"` are equivalent strings of`baseStr = "eed"`, and`"aab"` is the lexicographically smallest equivalent string of`baseStr`.

Return_the lexicographically smallest equivalent string of_`baseStr`_by using the equivalency information from_`s1`_and_`s2`.

**Example 1:**

**Input:** s1 = "parker", s2 = "morris", baseStr = "parser"

**Output:** "makkek"

**Explanation:** Based on the equivalency information in s1 and s2, we can group their characters as[m,p],[a,o],[k,r,s],[e,i].

The characters in each group are equivalent and sorted in lexicographical order.

So the answer is "makkek".

**Example 2:**

**Input:** s1 = "hello", s2 = "world", baseStr = "hold"

**Output:** "hdld"

**Explanation:** Based on the equivalency information in s1 and s2, we can group their characters as[h,w],[d,e,o],[l,r].

So only the second letter 'o' in baseStr is changed to 'd', the answer is "hdld".

**Example 3:**

**Input:** s1 = "leetcode", s2 = "programs", baseStr = "sourcecode"

**Output:** "aauaaaaada"

**Explanation:** We group the equivalent characters in s1 and s2 as[a,o,e,r,s,c],[l,p],[g,t] and[d,m], thus all letters in baseStr except 'u' and 'd' are transformed to 'a', the answer is "aauaaaaada".

**Constraints:**

*`s1`,`s2`, and`baseStr` consist of lowercase English letters.

1068\. Product Sales Analysis I

Easy

SQL Schema

Table:`Sales`

(sale_id, year) is the primary key of this table.

product_id is a foreign key to`Product` table.

Each row of this table shows a sale on the product product_id in a certain year.

Note that the price is per unit.

Table:`Product`

product_id is the primary key of this table.

Each row of this table indicates the product name of each product.

Write an SQL query that reports the`product_name`,`year`, and`price` for each`sale_id` in the`Sales` table.

Return the resulting table in**any order**.

The query result format is in the following example.

**Example 1:**

**Input:** Sales table:

Product table:

+------------+--------------+

| product_id | product_name |

+------------+--------------+

| 100 | Nokia |

| 200 | Apple |

| 300 | Samsung |

+------------+--------------+

**Output:**

**Explanation:** From sale\_id = 1, we can conclude that Nokia was sold for 5000 in the year 2008. From sale\_id = 2, we can conclude that Nokia was sold for 5000 in the year 2009. From sale\_id = 7, we can conclude that Apple was sold for 9000 in the year 2011.

selectproduct.product_name,sales.sale_year,sales.pricefrom sales

left join productonproduct.product_id=sales.product_id

packageg1001_1100.s1061_lexicographically_smallest_equivalent_string;

importstaticorg.hamcrest.CoreMatchers.equalTo;

importstaticorg.hamcrest.MatcherAssert.assertThat;

importorg.junit.jupiter.api.Test;

classSolutionTest {

voidsmallestEquivalentString() {

assertThat(

newSolution().smallestEquivalentString("hello","world","hold"),equalTo("hdld"));

}

voidsmallestEquivalentString2() {

assertThat(

newSolution().smallestEquivalentString("parker","morris","parser"),

equalTo("makkek"));

}

voidsmallestEquivalentString3() {

assertThat(

newSolution().smallestEquivalentString("leetcode","programs","sourcecode"),

equalTo("aauaaaaada"));

}

}

packageg1001_1100.s1068_product_sales_analysis_i;

importstaticorg.hamcrest.CoreMatchers.equalTo;

importstaticorg.hamcrest.MatcherAssert.assertThat;

importjava.io.BufferedReader;

importjava.io.FileNotFoundException;

importjava.io.FileReader;

importjava.sql.Connection;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.sql.Statement;

importjava.util.stream.Collectors;

importjavax.sql.DataSource;

importorg.junit.jupiter.api.Test;

importorg.zapodot.junit.db.annotations.EmbeddedDatabase;

importorg.zapodot.junit.db.annotations.EmbeddedDatabaseTest;

importorg.zapodot.junit.db.common.CompatibilityMode;

@EmbeddedDatabaseTest(

compatibilityMode =CompatibilityMode.MySQL,

initialSqls =

+" sale_year INTEGER, quantity INTEGER, price INTEGER); "

+"INSERT INTO Sales(sale_id, product_id, sale_year, quantity, price)"

+" VALUES (1, 100, 2008, 10, 5000); "

+"INSERT INTO Sales(sale_id, product_id, sale_year, quantity, price)"

+" VALUES (2, 100, 2009, 12, 5000); "

+"INSERT INTO Sales(sale_id, product_id, sale_year, quantity, price)"

+" VALUES (7, 200, 2011, 15, 9000); "

+"CREATE TABLE Product(product_id INTEGER, product_name VARCHAR); "

+"INSERT INTO Product(product_id, product_name)"

+" VALUES (100, 'Nokia'); "

+"INSERT INTO Product(product_id, product_name)"

+" VALUES (200, 'Apple'); "

+"INSERT INTO Product(product_id, product_name)"

+" VALUES (300, 'Samsung'); ")

classMysqlTest {

voidtestScript(@EmbeddedDatabaseDataSourcedataSource)

throwsSQLException,FileNotFoundException {

try (finalConnectionconnection =dataSource.getConnection()) {

try (finalStatementstatement =connection.createStatement();

finalResultSetresultSet =

statement.executeQuery(

newBufferedReader(

newFileReader(

+"s1068_product_sales_analysis_i/script.sql"))

.lines()

.collect(Collectors.joining("\n"))

.replaceAll("#.*?\\r?\\n",""))) {

assertThat(resultSet.next(),equalTo(true));

assertThat(resultSet.getNString(1),equalTo("Nokia"));

assertThat(resultSet.getInt(2),equalTo(2008));

assertThat(resultSet.getInt(3),equalTo(5000));

assertThat(resultSet.next(),equalTo(true));

assertThat(resultSet.getNString(1),equalTo("Nokia"));

assertThat(resultSet.getInt(2),equalTo(2009));

assertThat(resultSet.getInt(3),equalTo(5000));

assertThat(resultSet.next(),equalTo(true));

assertThat(resultSet.getNString(1),equalTo("Apple"));

assertThat(resultSet.getInt(2),equalTo(2011));

assertThat(resultSet.getInt(3),equalTo(9000));

assertThat(resultSet.next(),equalTo(false));

}

}

}

}