### Question:
Relations { @NonNull public List<TweetWithUser> getTweetWithUser() { return storIOSQLite .get() .listOfObjects(TweetWithUser.class) .withQuery(RawQuery.builder() .query("SELECT " + TweetsTable.COLUMN_ID_WITH_TABLE_PREFIX + " AS \"" + QUERY_COLUMN_TWEET_ID + "\"" + ", " + TweetsTable.COLUMN_AUTHOR_WITH_TABLE_PREFIX + " AS \"" + QUERY_COLUMN_TWEET_AUTHOR + "\"" + ", " + TweetsTable.COLUMN_CONTENT_WITH_TABLE_PREFIX + " AS \"" + QUERY_COLUMN_TWEET_CONTENT + "\"" + ", " + UsersTable.COLUMN_ID_WITH_TABLE_PREFIX + " AS \"" + QUERY_COLUMN_USER_ID + "\"" + ", " + UsersTable.COLUMN_NICK_WITH_TABLE_PREFIX + " AS \"" + QUERY_COLUMN_USER_NICK + "\"" + " FROM " + TweetsTable.TABLE + " JOIN " + UsersTable.TABLE + " ON " + TweetsTable.COLUMN_AUTHOR_WITH_TABLE_PREFIX + " = " + UsersTable.COLUMN_NICK_WITH_TABLE_PREFIX) .build()) .prepare() .executeAsBlocking(); } Relations(@NonNull StorIOSQLite storIOSQLite); @NonNull List<TweetWithUser> getTweetWithUser(); @NonNull
    static final String QUERY_COLUMN_TWEET_ID; @NonNull
    static final String QUERY_COLUMN_TWEET_AUTHOR; @NonNull
    static final String QUERY_COLUMN_TWEET_CONTENT; @NonNull
    static final String QUERY_COLUMN_USER_ID; @NonNull
    static final String QUERY_COLUMN_USER_NICK; }### Answer:
@Test public void name() { SampleApp sampleApp = (SampleApp) RuntimeEnvironment.application; sampleApp.appComponent().storIOSQLite() .put() .objects(asList( Tweet.newTweet(1L, "artem_zin", "test tweet 1"), Tweet.newTweet(2L, "artem_zin", "test tweet 2"), Tweet.newTweet(3L, "nikitin-da", "test tweet 3"), User.newUser(1L, "artem_zin"), User.newUser(2L, "nikitin-da")) ) .prepare() .executeAsBlocking(); Relations relations = new Relations(sampleApp.appComponent().storIOSQLite()); List<TweetWithUser> tweetsWithUsers = relations.getTweetWithUser(); assertThat(tweetsWithUsers).hasSize(3); assertThat(tweetsWithUsers.get(0)).isEqualTo(new TweetWithUser(Tweet.newTweet(1L, "artem_zin", "test tweet 1"), User.newUser(1L, "artem_zin"))); assertThat(tweetsWithUsers.get(1)).isEqualTo(new TweetWithUser(Tweet.newTweet(2L, "artem_zin", "test tweet 2"), User.newUser(1L, "artem_zin"))); assertThat(tweetsWithUsers.get(2)).isEqualTo(new TweetWithUser(Tweet.newTweet(3L, "nikitin-da", "test tweet 3"), User.newUser(2L, "nikitin-da"))); }